What is Central Management in SQL Server ?

SQL Server introduced a new method of administering multiple servers by enabling you to designate a Central Management Server. An instance of SQL Server that is designated as a Central Management Server maintains a list of registered servers. A typical usage for a DBA is to write a single query across servers to know the Version post a patch update across servers.



You May Interest

What are Isolation Levels in SQL Server ?

What is The Difference Between The Index Seek and Index Scan in S ...

Getting Rows in a Table in Random Order in MS SQL

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

MS SQL Finding Which Tables a Column Name is In