3

I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.

HopelessN00b
  • 53,385
  • 32
  • 133
  • 208
Cade Roux
  • 375
  • 2
  • 5
  • 18

1 Answers1

3

Yes, you can use the Script Manager to run one or more queries/scripts against multiple servers/databases.

Toad for Data Analysts has a Group execute feature built into the editor, which I personally prefer over the Script Manager.

You can learn more at Toad Executing Scripts against Multiple Databases.

  • Here's a link to see how the Group Execute works http://www.thatjeffsmith.com/archive/2010/06/introducing-toad-for-sql-server-part-1/ –  Oct 20 '10 at 18:54