January 25, 2008 at 3:43 pm
Is there any potential issue if we update the srvname in the master..sysservers?
Any input will be greatly appreciated.
January 25, 2008 at 3:53 pm
If you are trying to rename the local SQL Server, this is the way:
exec master.dbo.sp_dropserver 'CurrentServerName'
exec master.dbo.sp_addserver 'NewServerName','local'
January 25, 2008 at 7:58 pm
Why would you want to update it? What are you trying?
_____________
Donn Policarpio
January 27, 2008 at 10:19 am
This server is relative old. For some reasons, its name was modified by someone. As a result, any job created before this rename could not not be modified without some additional change.
I know how to update the content in the table, sysservers. But I would like to discuss with others and see what potential danger I may come across because it is a server in a production environment.
Once again, any input will be greatly appreciated.
January 27, 2008 at 11:32 am
It should not be a problem. I ever do it before. Anyway you don't have choice right? 😀
You may refer to the steps given by Jane Matheson
http://www.sqlservercentral.com/Forums/Topic442945-146-1.aspx#bm445652
January 27, 2008 at 1:57 pm
I never tried it tho. But if I would, I'll try it out first on a dev somewhere, or look what sp_addserver/sp_dropserver really does, see if there's any dependent tables to be modified aside sysservers. 😉
_____________
Donn Policarpio
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply