Advertisements
SQL server registered server usage
It is very useful for DBAs and junior DBAs to collect information from all the servers, reports etc.
Example: Collect all the logins, jobs, larger database size from all the 300+ servers etc.
It is per user, each one needs to create their own category version wise or environment wise.
Make sure, the query will run all the servers, try to use select mostly, if you are performing and DDL or DML verify it before running, since it will make changes in all the servers.
You can also use centralized management server, it is for all users.
