Wednesday, March 28, 2012

How to change SQL Server Name

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.

No comments:

Post a Comment