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: 728164
October 29, 2004 at 1:51 pm
#528441
don't forget to drop the old server with sp_dropserver
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply