여러 서버들을 중앙 서버에 등록해서 관리하기

Registered Server, a Hidden Gem of SQL Server Management Studio. Part 1 – {coding}Sight (codingsight.com)

Registered Server, a Hidden Gem of SQL Server Management Studio. Part 1 – {coding}Sight

SELECT      
      G.name AS [Group Name],
      S.name as [Server Alias],
      S.server_name AS [Server Host Name]   
FROM    msdb.dbo.sysmanagement_shared_server_groups_internal G
LEFT JOIN msdb.dbo.sysmanagement_shared_registered_servers_internal S
      ON G.server_group_id = S.server_group_id
WHERE G.server_type = 0 --only the Database Engine Server Group
AND server_name IS NOT null