central-management-server Archives

Execute Stored Procedure against CMS from within a SQL Server Agent job

By adminPosted on August 18, 2022

Question : Is it possible to execute a stored procedure (or any T-SQL) against a Central Management Server (CMS) via […]

By adminPosted on July 8, 2022

Question : I’d like to provide a “directory” of all the different SQL Servers we have our different DEV, TEST, […]

By adminPosted on May 12, 2022

Question : I have set up a Central Management Server in SQL Server. When I try to add a new […]

By adminPosted on April 24, 2022

Question : I am querying a group under a Central Management Server, which results in the following being logged to […]

By adminPosted on February 12, 2022

Question : I have created a CMS website that only had one database connection for both the admin area and […]

By adminPosted on January 28, 2022

Question : I’m setting up a SQL Server 2012 lab on Windows 2008 R2 which has 5 SQL Servers. I […]

By adminPosted on January 17, 2022

Question : I need to delete users from all the instances in my domain. In order to do that, I […]

By adminPosted on December 10, 2021

Question : I’ve got to believe there’s a reason for this, but for the life of me I cannot figure […]

By adminPosted on June 2, 2021

Question : I have created a CMS website that only had one database connection for both the admin area and […]

By adminPosted on January 19, 2021

Question : I like the idea of setting up a Central Management Server to run queries against other servers that […]