Rename SQL server Server

  • 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 .

  • If you run SELECT [name] FROM sys.servers, do you see the old server name, or the new one?

    John

  • 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.

  • 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