MS SQL Server - System Rollback

Asked May 08 '14 at 17:15

Active May 08 '14 at 17:26

Viewed 43 times

We have a looped procedure which does a high volume data processing of transcating, loading and merging two tables using split and merge. During the data processing the system is rolling back the processed data even though there are no explicit rollbacks set up on the procedures.

Are there situations where the SQL Server will automatically rollback these transactions when there is not enough space or if something is wrong with the proc.

There are no validation errors in the procedure or any message while the procedure is executed. The data just disappears.

Thank you for your time and help.

edited May 08 '14 at 17:26

RBarryYoung

55,398
14
96
137

asked May 08 '14 at 17:15

user3617194

Do you actually see the process in the rollback state or are you just inferring that? – RBarryYoung May 08 '14 at 17:37
Yes. I see the Rollback against the SP'sSPID. – user3617194 May 08 '14 at 17:39
Yes, there are things that can cause this. We would need to know a lot more about your procs to figure out what the likely cause is. – RBarryYoung May 08 '14 at 17:40
Have you checked the SQL Server Error log? – RBarryYoung May 08 '14 at 17:41
Thank you for your responses. All I got from the logs is this. (@P0 int OUTPUT)EXEC @P0 = Stored Procedure name with SLEEP_BPOOL_FLUSH. – user3617194 May 09 '14 at 13:29

MS SQL Server - System Rollback

0 Answers0