Is there a Query Analyzer

[click37]

in the market place that will run a query on multiple DBs across
multiple servers? Without having to manually connect to each server?
If so, can anyone provide a link for it.

Thanks

[Josh Assing]

"it depends"

I might be able to write you a custom program for free to do it if you give me
more details.

There's ways to send a query to an sql server via script; but it's not pretty.

Tell us more about what you need to do; or email me off the NG if you want a
mini app

-j
On 20 Feb 2007 14:04:44 -0800, cl*****@gmail.com wrote:

>in the market place that will run a query on multiple DBs across
multiple servers? Without having to manually connect to each server?
If so, can anyone provide a link for it.

Thanks

--- AntiSpam/harvest ---
Remove X's to send email to me.

[click37]

Say I want to run this script:

Select * from company

I need it to run on DB1, DB2, DB3, DB4 and DB5

DB1 and DB2 are located on Server1
DB3 is on Server2
DB4 and DB5 is on Server3

The long and manual way I would have to do it, is copy the SQL smt.
Connect to Server1, paste and run it on DB1, then DB2. Connect to
Server 2, run it on DB3 and so on.

Is there a way to configure the script that will allow me to run the
query once, and it'll give me the results from all the DBs I want it
to hit ?
Thanks for helping.
On Feb 20, 8:57 pm, Josh Assing <[e-mail]:

"it depends"

I might be able to write you a custom program for free to do it if you give me
more details.

There'sways to send aqueryto an sql server via script; but it's not pretty.

Tell us more about what you need to do; or email me off the NG if you want a
mini app

-j

On 20 Feb 2007 14:04:44 -0800, [e-mail] wrote:

in the market place that will run aqueryon multiple DBs across
multiple servers? Without having to manually connect to each server?
If so, can anyone provide a link for it.

Thanks

--- AntiSpam/harvest ---
Remove X's to send email to me.

[Robert Klemme]

On 22.02.2007 16:04, cl*****@gmail.com wrote:

Say I want to run this script:

Select * from company

I need it to run on DB1, DB2, DB3, DB4 and DB5

DB1 and DB2 are located on Server1
DB3 is on Server2
DB4 and DB5 is on Server3

The long and manual way I would have to do it, is copy the SQL smt.
Connect to Server1, paste and run it on DB1, then DB2. Connect to
Server 2, run it on DB3 and so on.

Is there a way to configure the script that will allow me to run the
query once, and it'll give me the results from all the DBs I want it
to hit ?

Whatever you do, you will have to at least once authenticate to each
machine. With SQL 2005 Management Studio you can store credentials - or
you use Windows authentication. Then no additional login is required.

HTH

robert