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.
–> 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?