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 :
SELECT @@servername as Servername, name as DBName,[crdate] AS [LastStartupDate]
WHERE [master].[dbo].[sysdatabases].[name] = 'tempdb'
Can I save the results in a table on the same server where I setup central management server ?