There are 3rd party tools that allow you to run a query or queries against multiple servers in parallel. See SQL Farm Combine for example, http://www.sqlfarms.com.

I apologize for the sales pitch in advance but we are looking for Beta2 participants with many SQL server. Would this be of interest to anyone on this thread? On...

There is a best development and deployment practices presentation that runs around the internet. It is typically given to SQL User Groups and in Code Camps... Enjoy...

http://www.itresourcepartners.com/bssug/downloads/BestCodingPractices.ppt

BTW- You can always tools like SQL Farm Combine to run the simple query against as many databases as you wish, across multiple servers as well.

You can connect to all databases (either on the same server or on different servers) and run the query/script and get aggregated results using tools such as SQL Farm Combine....

Union all should work fine. Union vs. union all is really not the answer, since if one doesn't merge, the other wouldn't merge either.

Check out your SQL code. I would...

Using Query Analyzer, try to log into the master database.

Then run SELECT * FROM master.dbo.sysdatabases

The scenario you describe is quite common when the master database on the server gets corrupt,...

Several things need to be commented regarding your question:

1. Question: Are you creating the schema on the target servers yourself, or are you letting the publisher create the schema on...

You can use tools like SQL Farm Combine from http://www.sqlfarms.com, to deploy the code on all your databases and servers in parallel by a click of a button,...

Check out SQL Farm Combine at http://www.sqlfarms.com.

Using this tool you can query all 19 servers in parallel into a single grid results, and dump the results into a...

The example you provided is great. One comment though- the same goal can be achieved without any development efforts by running simple SQL queries on all databases and servers in...

If you have many servers, you can query and return data from all of your servers at the same time to collect the information you need using SQL Farm Combine....

Just to add to the above:

SQL Farm Combine will be available for Beta testers on Thursday.

Please refer to last month's SQL Server Magazine or SQL Server Standard that came out...

Look at the SQL Farm Combine from SQL Farms. It lets you query multiple databases and servers at the same time, and does what you seek.

Please note that a script that synchronizes your server logins is available on SQL Farms' SQL Education Center at

http://education.sqlfarms.com/ShowPost.aspx?PostID=80

It's free...