Updating sys servers

good thing I have already written about how to do that, so I don’t need to do that again here. It is a good thing to know if your environment has changed.

All too often I would find that developers with too much access would go into a server and create or modify linked servers for their own use.


You can follow the below steps to update the SQL Server system metadata which stores the physical server name in sys.servers.Tearing things down and rebuilding it is painful, but its by far the safest thing to do.



  1. Pingback:

  2. eric   •  

    Watch great xxx sex videos and pornos at the best free pussy and porn tube site on the web.

  3. eric   •  

    Nearly a decade ago, we started Experience Project with a mission of harnessing social media to bring empathy and understanding to all, through the power of anonymously shared human experience.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>