Question : This question already has answers here: Use sp_Blitz to gather information on all servers in a centralized server/database […]
Tag: central-management-server
Is it possible to run query against only part of the Central Managed Servers?
Question : For example, I want to run this query to get the status of some servers having high availability […]
Execute Stored Procedure against CMS from within a SQL Server Agent job
Question : Is it possible to execute a stored procedure (or any T-SQL) against a Central Management Server (CMS) via […]
Registered Servers without the ability to connect to Multiple Servers at once
Question : I’d like to provide a “directory” of all the different SQL Servers we have our different DEV, TEST, […]
Can I use SQL Server Authentication for Central Management Servers?
Question : I have set up a Central Management Server in SQL Server. When I try to add a new […]
Login failure error log when querying Central Management Server group
Question : I am querying a group under a Central Management Server, which results in the following being logged to […]
How many database users/admins should be created for a website?
Question : I have created a CMS website that only had one database connection for both the admin area and […]
Central Management Server – can it manage itself?
Question : I’m setting up a SQL Server 2012 lab on Windows 2008 R2 which has 5 SQL Servers. I […]
How to populate central management server registration from a list
Question : I need to delete users from all the instances in my domain. In order to do that, I […]
Case Sensitive Ordering within the CMS Server List
Question : I’ve got to believe there’s a reason for this, but for the life of me I cannot figure […]
- 1
- 2