dan9001
SSChasing Mays
Points: 600
More actions
October 29, 2004 at 11:10 am
#85704
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"?
Wesley Brown
SSChampion
Points: 12045
October 29, 2004 at 12:17 pm
#528428
sp_addserver 'newservername', 'local'
Look it up in BOL
Wes
Steve Jones - SSC Editor
SSC Guru
Points: 738632
October 29, 2004 at 1:51 pm
#528441
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