Post reply

Potential issue of updating master..sysservers?

  • January 25, 2008 at 3:43 pm

    #71354

    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

    #772055

    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

    #772087

    Why would you want to update it? What are you trying?

    _____________
    Donn Policarpio

  • January 27, 2008 at 10:19 am

    #772206

    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

    #772226

    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://qa.sqlservercentral.com/Forums/Topic442945-146-1.aspx#bm445652

  • January 27, 2008 at 1:57 pm

    #772238

    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