InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:52:14 GMT20http://www.sqlservercentral.com/Forums/Topic1379055-391-1.aspx[quote][b]sqlserver12345 (10/30/2012)[/b][hr]I am able to run a query in central management server created on one of the SQL servers lets say CMSServer1.I would like to store the result set of a query on the same server CMSServer1 in a database/table (TestSQLServer/Table_1) where I created the CMS.How I do I do this ?Running this query in CMS :insert into Table_1 SELECT @@servername as Servername, name as DBName,[crdate] AS [LastStartupDate]FROM [master].[dbo].[sysdatabases],[dbo].[Table_1]WHERE [master].[dbo].[sysdatabases].[name] = 'tempdb'and [TestSQLServer].[dbo].[Table_1].LastStartUpTime < [master].[dbo].[sysdatabases].crdate[/quote]Something seems to be missing from your post. What is wrong with the query as you posted it?Wed, 31 Oct 2012 08:19:00 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1379055-391-1.aspxI am able to run a query in central management server created on one of the SQL servers lets say CMSServer1.I would like to store the result set of a query on the same server CMSServer1 in a database/table (TestSQLServer/Table_1) where I created the CMS.How I do I do this ?Running this query in CMS :SELECT @@servername as Servername, name as DBName,[crdate] AS [LastStartupDate]FROM [master].[dbo].[sysdatabases]--,[dbo].[Table_1]WHERE [master].[dbo].[sysdatabases].[name] = 'tempdb'Can I save the results in a table on the same server where I setup central management server ?Tue, 30 Oct 2012 15:39:19 GMTsqlserver12345