-
Implications of sp_dropserver
I need to rename my server and i believe i have to use dropserver and addserver. What are the implications of using these commands. Will I lose any data or anything?
Thanks
Nick
-
you need to update master..sysservers and msdb..sysjobs table when you change the server name.
refer
http://databasejournal.com/features/...le.php/2194711
Please do not post the same qustion multiple times.
-
Don't forget specify local when run sp_addserver.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|