Home Forums SQL Server 7,2000 Administration Renaming a SQL 2K Server? RE: Renaming a SQL 2K Server?
Tommy Bollhofer
SSChampion
Points: 14940
More actions
February 19, 2008 at 3:05 pm
#779961
A simple verification - on the server in question, execute a
select @@servername
If this returns the correct server name then you are all done. If not use the sp_dropserver, sp_addserver method to change the name.
Tommy