Post reply

How to register servers using a script?

  • June 14, 2010 at 4:48 pm

    #225608

    I have a table contains all info about servers. How do I use this table to register SQL Server instances in my SSMS?

    Many input will be greatly appreciated.

  • June 15, 2010 at 12:02 am

    #1180203

    You need add all servers to RegSrvr.xml file which is stored in C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell for SQL 2008 on Windows 2008 and for SQL 2005 it should be in C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply