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
Printable View
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.