Post reply

SSMS REGISTERED SERVERS !!

  • July 21, 2016 at 9:53 am

    #328030

    Is there a query or way to register 100 server name with one query and you will see all the list in your left panel of register server or do i have to enter individually instance name and enter one by one to register all servers ?

  • July 21, 2016 at 10:14 am

    #1891381

    I guess you could generate a .regsrvr file. Here's an article on exporting it https://www.mssqltips.com/sqlservertip/2015/import-and-export-registered-sql-servers-to-other-machines/. If you write the code to generate the xml for all the servers, you could import that file.

    I haven't tried it, but you could.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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