SQl Server Registered Servers tables

SQL Server Administration
1

Hi experts,
I have added 50 server names into a node named PROD in registered servers. The name appear in the left-side panel and I can run queries against them. There are few duplicates i would like to clean up, even though the dups don't appear in the panel.

When I run this, it doesn't return any rows.
SELECT *
FROM [msdb].[dbo].[sysmanagement_shared_registered_servers]

0 rows

Which table contains the registered servers?
Thanks

2

sysmanagement_shared_registered_servers is for Centeral Management Server

For local SSMS registered Server, see this thread at StackOverflow

1 Like
3

Thank you, khtan.

4

[msdb].[dbo].[sysmanagement_shared_registered_servers_internal] is the table name I was trying to think of. I can paste the name of my servers form excel into this table using a hardcoded value for server group id.
This thread can be closed.