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-11 : 09:42:14
|
| Hi everyone,I have configured CMS on my 2008 R2 server.I have a CMS node containing several SQL 2005 server names.I want to query info from those servers and insert the results into a database that resides on the local instance. But when I run this within the "2005" node:Insert into DatabasesInventory.dbo.DatabaseInfo(DatabaseName, FileName, DateCreated, CompatibilityLevel, AsOfDate) select name,filename, crdate, cmptlevel, GETDATE() from sysdatabases;it fails with "Invalid object name 'DatabasesInventory.dbo.DatabaseInfo'."My question is: Is there a way to write the info to a non-CMS database?Hope my question is clear.Thanks, John |
|
|
|
|
|
Retrieve Data from Central Management Servers