You are here: Re: Is there a Query Analyzer « MsSQL Server « IT news, forums, messages
Re: Is there a Query Analyzer

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация