Hi all,
I have a server with machine name as ABC with SQL Server 2000 in it.
Executing Select @.@.Servername gave me ABC before but after i changed the Machine name to XYZ @.@.Servername is still showing ABC. can somebody tell me how to change the SQL Server name to That of the machine i.e XYZ.
This should help:
http://support.microsoft.com/kb/303774
|||Thank You Sir that was very helpful.We have number of cubes which built under ‘abc’ database schema, but recently database schema has changed to ‘xyz’ (table names still are same), so every dimension tables, fact table need delete not change when refresh in DSV (BI Studio SQL server2005). If delete tables in DSV, means rebuild dimensions, and cube in the BI Studio. Is there a way to change schema name in DSV instead of rebuild cube from scratch?
Thanks in advance for advice.
Hello!Open your DVS and select xml source and directly replace DbSchemaName="abc" with DbSchemaName="xyz".
Hth,
Radim
|||Great! It works.
Thank you so much Radim.
sql
