How to add a server list into Registered Servers on Microsoft SQL Server Management Studio (SSMS) I have a list of sqlserver on on table on tbl_servers which have 500 server.
example:
Select IP_instance, DBname, username, password from tbl_servers
which will return the all sql server and their sa credential.
--&gt; 10.10.1.30, myDatabase, sa, password
I would like to add all of this into the Registered server, can this done by SQL scripting? or any faster way to add?
Phil Factor wrote a great article at the Simple-talk website that includes this and much other useful information
https://www.red-gate.com/simple-talk/sql/sql-tools/registered-servers-and-central-management-server-stores/