Running Query on Multiple Database/Servers

• ShuaibV

  SSCommitted

  Points: 1999

  More actions

  March 20, 2013 at 4:20 pm

  #291399

  Hi

  I have a database table that contains all the server details. I have a query and wanted to run against all servers available in the table.

  Sample Query:

  SELECT DISTINCT Col1, Col2 FROM dbo.Test

  Requirement

  1. Connect to one server

  2. Run the Query against all the user DB and save the results into a table.

  Please suggest a best way to from SQL server.

  Thanks

  Shuaib

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  March 20, 2013 at 4:52 pm

  #1599186

  Have a look at this, perhaps it will help.

  http://msdn.microsoft.com/en-us/library/ms188427(v=sql.105).aspx

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  March 23, 2013 at 2:27 pm

  #1600076

  Here is how you would do it using SSIS:

  Iterate Over Databases Using SSIS – Part 2[/url]

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato