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_nameGO
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