August 24, 2010 at 1:47 am
Good Day,
We are running SQL Server 2005 on WIndows 2003 . We renamed the servername on the Operating System and a few seconds later I detected that the name in SQL Server was also changed . Does this now suggest that sp_dropserver and sp_addserver are now obsolete ? Any ideas ?
Thanks .
August 24, 2010 at 1:54 am
If you run SELECT [name] FROM sys.servers, do you see the old server name, or the new one?
John
August 24, 2010 at 2:19 am
John,
thank you for your e-mail. I ran the query as suggested by you. The only name that is displayed is the new name of the server .
Regards.
August 24, 2010 at 4:26 am
Does this now suggest that sp_dropserver and sp_addserver are now obsolete
Thanks .
They are not obsolete. Please refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply