Friday, February 24, 2012

change sql 2005 server name

I have Sql Server 2005 on my computer and i want to change the name of the server. I found this procedure but i didn't understand how it worked. So the actual name of my server is STATIE4 and i want to change it.

I executed this procedure, but the name of the server is still STATIE4. If i write sp_helpserver STATIE4 it doesn't find STATIE4. What have changed after using this procedure?

sp_dropserver old_name

GO

sp_addserver new_name, local

GO

to restart your SQL Server service. Connect agin and run the following command (It should output the new server name):

SELECT @.@.SERVERNAME
GO

HTH

No comments:

Post a Comment