Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2012-05-08 : 23:02:50
|
| Hello,I have configured CMS in my 2008 R2 instance. Then added 2 2005 servers to a group named "2005".But when I run this query within 2005, it cannot find the tables I'm referencing. I have found examples from others using this technique.What am I doing wrong?SELECT DISTINCT s.[server_name] as [server]FROM [msdb].[dbo].[sysmanagement_shared_server_groups_internal] gJOIN [msdb].[dbo].[sysmanagement_shared_registered_servers_internal] s ON g.[server_group_id] = s.[server_group_id];Invalid object name 'msdb.dbo.sysmanagement_shared_server_groups_internal'.Invalid object name 'msdb.dbo.sysmanagement_shared_server_groups_internal'.Thanks, John |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2012-05-09 : 10:28:17
|
| ** Resolved **I apologize for this post.When I run my query against the msdb database on the central instance, the tables are found and the query returns edata. (I was running it within the 2005 group of managed servers.)Closing this post. Thanks |
 |
|
|
|
|
|
Using Central Management Server (CMS)