Agree with Andy.

Sin

ThomasSH,

Thanks for your clarification.  I will make the same change to the copy of the your script then. 

I am evaluating different options. I think the difference between your script...

I have just tested it and it works great.  Except I have to get into setting up my server as MSX (Master Server) and then my restore db job has...

Oh, that sounds good.  But does the sp_start_job return to the main process right away, or does it wait until my new backup job finish?

Thanks.

Sin

Hi ThomasH,

So pretent I have a sp that called "BackupAndRestoreMyDB_SP"

So does that mean I can add to my schedule Job to call:

 EXEC SyExecSQLSyncSP...

Thanks for everyone's friendly input.  I learnt many different things.

The CommandTimeout Property did it.  It works now. THANKS.

Sin

Reply to #2)  I will check tomorrow.

Reply to #3) I don't have a Transform Data Task, all I have is one Task called ActiveX Script Task in that DTS package. ...

1) Good point, I have not checked the Execution Plan.  I should try to improve its performance anyways.  How would I do that?

2) I am running SQL Server 2000 on...

I don't think this is a run away loop because I had it working once before and hasn't been changed since then.

The stored procedure however has been updated to be...