General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>Is the entire thing under one transaction? I've had issues with really large long running transactions. Try breaking it into smaller ones.
>
>Are you being blocked by something else? When things look stalled, fire off sp_who on another connection and look for a value in the BLK column.
>
>Are you sure that it's not doing anything? How can you tell?
>
>-Mike
Thanks for responding, Mike. No, I'm not using explicit transactions, having experienced problems with the same in this case. Also, I'm the only user on the server so I can't see how I'd be blocked. Finally, I know nothing is happening because:
1. I'm logging each query in sequence and no entries occur after the one that logs the 4.6 million row insert. I'm also trapping for query errors and none are appearing.
2. No rows appear in the target table with column values corresponding to those in the next INSERT in the SP.
After I posted my first message, I also eliminated the possibility of a problem with the log file by changing the recovery mode to Simple and rerunning the SP - no change.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only