central-management-server Archives

Gathering sp_BlitzFirst data into a centralized database [duplicate]

By adminPosted on January 31, 2023

Question : This question already has answers here: Use sp_Blitz to gather information on all servers in a centralized server/database […]

By adminPosted on January 13, 2023

Question : For example, I want to run this query to get the status of some servers having high availability […]

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 […]