SQL server registered server CMS usage


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.


I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 56 = 62