Posted by Robert Klemme on 02/24/07 15:02

On 22.02.2007 16:04, click37@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

[Back to original message]