Are these procs that you want to run going to generate a report or fill a table with data that will be used later by the reports?

If they are preparing...

Sounds like the tables on the different servers have different data.

You definitely want that trigger file to be sent after the data file has finished transmission.  Its job isn't to announce that the data file exists, rather it should indicate...

SSIS or an OSQL run from Task Manager - if the later, be sure to redirect the output to a log file so you can verify everything happened as you...

Sounds like someone is using this to turn off the result values.  I wonder if the application that calls the stored procedures knows about this value?

The code I posted is for 2000, haven't had an opportunity to look at the setup for 2005 yet.

If you fetch your data from a stored procedure, it could return the columns moved into the ordering you want.

You could have a second data source to tell you the...

i like the idea too

I'll weigh in on the one database per application side.  Its much more convenient to move an appilcation database to another server when its seperated out from the others.  Its...

If you are using integrated security to log into the sql server then leave out the /U and /P as they would be interpreted as SQL logins

try the TextCopy tool http://www.databasejournal.com/features/mssql/article.php/1443521

Make yourself an old fashioned DOS Bat file that runs OSQL on each of the procs, one at a time.  Then the procs will be installed in the order of...

You should set up a loop that looks something like (C#ish)

TryAgain = true;

while (TryAgain)

{

    TryAgain = False;

    try

    {

        Submit the query

    }

    catch (Exception e)

    {

        if (e.Message.InStr("Deadlock") >...

There's no way I know of in SQL to detect the deadlock, mostly because sql server terminates the deadlock process chosen as victim.  You'll have to have the application that submitted...

Link to the SQL table if you want to be able to manipulate the data on the SQL Server.  Import the SQL table if you only want to manipulate it in...