Application group like 'control' and don't want use SSIS

BTW, the inked server timed-out is set to 0 (connection time query time out) which suppose means no timed-out

General Network error. I don't think blocking is the cause as I mentioned earlier, it only failed if running against 2 diff databases at at same time. Blocking seems talking...

Thank you for the input, adding a row_count / hide it and get max of the value seems working perfect for me and a lot less work.

Below is actual code (except decalre variables). Hope you can shed some light to see how I may can make it works better

declare MG cursor for

...

Let me try it I can do better this time, below is the code and some comments

-- read client data from staging table and basd on the increment value, update...

I really appreciate someone come up help so fast. OK before there is another piece of code to open another cursor like below (its like cursor in a cursor ...

Guess why, it is a vendor software, I can't change table design.

The vendor send a large ASCII file for multiple clients which it loaded to a staging table.

The...

I am very interested to see the restore metrics. What OS are you based on ?

Application conneceted in various way, APP server, WebSphere, fat client (both ODBC and OLE)

Sure did, bumped from default 25 to 500, same issue.

Sure did, bumped from default 25 to 500, same issue.

110% sure is not the case (I/O), we're able to re-produce the problem on various system, H/W ranging from SCSI 3 to fiber to EMC. It sounds more like a setup...

Global temp table won't work for me in my situation. As this SP need create/run parallel in multiple databases in a huge SQL server (SAN) for various clients.

Yes, the method  you mentioned is what I know. I'm just wondering there is any easier (one command) way to do. I did this way before, somehow is some odd...