CMS configuration

There has to be a documentation for CMS.  This application related more than database related.

CMS is related to Database. I'm talking about central management server, which comes with SQL.

Sorry I thought CMS stood for Content Management Server.  Sorry, I have never used Central Management Feature. My guess is the usage is stored in msdb but I hope somebody will confirm.  In this case, backing up / restoring msdb database should help migrate but I am not sure where content is stored.

I believe it's doesn't store in msdb. When create a temp variable, it stored in a each corresponding server.

Hi,

Are you talking about multi-server queries, where you can select node on the CMS Tree in Registered Servers etc.

I think that the queries are managed by SSMS rather than by the database engine, so I don't believe that results can be stored in a database.

Regards
  David

Yes, I ran the query and i want to import the resultant to one database.

Hi

I couldn't find how to do this myself, so my workaround was a power shell script with list of servers in a table. Results stored in a table.

You can't just store results from a query in a table.

Only way is if all servers in node have same linked server, pointing to same server, then multi-server query can be an insert.

HTH
  David

Does anyone have tried this? Is there any other work around solution in SSMS?
Apart setting up the linked server?

Any experts call?Please help. I still looking for an solution.

Perhaps explaining what you are trying to achieve exactly may help experts help you better.  We may for instance recommend a workaround solution.