Skip to main content
Tweeted twitter.com/StackDBAs/status/686510724680663040
Post Merged (destination) from dba.stackexchange.com/questions/125804/…
Incorporated comment
Source Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

I have 50 servers. I manage them from a central management server on SQL Server 2014 Enterprise Edition. I don't use repository.

I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.

Is this possible and if so, how?

I have 50 servers. I manage them from a central management server.

I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.

Is this possible and if so, how?

I have 50 servers. I manage them from a central management server on SQL Server 2014 Enterprise Edition. I don't use repository.

I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.

Is this possible and if so, how?

added 22 characters in body
Source Link
Ebrahim
  • 103
  • 1
  • 2
  • 9

I'veI have 50 server,servers. I manage them withfrom a central management server,.

I could open a query and get result for each one at the same time. But But I want to do it in automationan automated way, like a job, to collect data from each server and keep on the local, Isstore/handle it possible?locally.

I need helpIs this possible and if so, thanks.how?

I've 50 server, I manage them with central management server, I could open query and get result for each one at same time. But I want to do it in automation way, like a job, to collect data from each server and keep on the local, Is it possible?

I need help, thanks.

I have 50 servers. I manage them from a central management server.

I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.

Is this possible and if so, how?

Source Link
Ebrahim
  • 103
  • 1
  • 2
  • 9

Collect data with central management servers and keep them in local table

I've 50 server, I manage them with central management server, I could open query and get result for each one at same time. But I want to do it in automation way, like a job, to collect data from each server and keep on the local, Is it possible?

I need help, thanks.