• Here is a link to an MSSQL tip: http://www.mssqltips.com/sqlservertip/2397/sql-server-central-management-servers-system-tables/. That is an article that explains how to get the Central managmeent server list.

    To access using a linked server, you can use Openquery (You can google that), or just a select * from linkservername.databasename.schemaname.tablename.

    And, the last couple of days, I have been recommending Powershell, on a couple of these forums, to do exactly what you need to do. Very easy to set up and run as a scheduled job, and you can access multiple servers. I have used it for 4 or 5 years now, and it works great.

    Leonard