InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:34:41 GMT20http://www.sqlservercentral.com/Forums/Topic973894-146-1.aspx[quote][b]Does this now suggest that sp_dropserver and sp_addserver are now obsoleteThanks .[/quote]They are not obsolete. Please refer [b][url=http://msdn.microsoft.com/en-us/library/ms143799.aspx]this[/url][/b]Tue, 24 Aug 2010 04:26:16 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic973894-146-1.aspxJohn,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.Tue, 24 Aug 2010 02:19:47 GMTlianvhhttp://www.sqlservercentral.com/Forums/Topic973894-146-1.aspxIf you run SELECT [name] FROM sys.servers, do you see the old server name, or the new one?JohnTue, 24 Aug 2010 01:54:12 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic973894-146-1.aspxGood 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 .Tue, 24 Aug 2010 01:47:00 GMTlianvh