How to Update SQL Server 2000 Name?

  • select @@servername returns "Server1". 

    But, the actual name of the server has been changed to "Server2".  How do I change the SQL2K database to "Server2" so that

    select @@servername returns "Server2"?

     

     

  • sp_addserver 'newservername', 'local'

    Look it up in BOL

    Wes

  • don't forget to drop the old server with sp_dropserver

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply