January 5, 2006 at 12:43 am
Hi guys and girlz
I have a strange thing going on in query analyzer.
I ran a very large stored procedure. Query completed it says. But when we look in the log i had a rollback transaction.
How can that be ?
Query batch completed versus rollback. Dont' know where to look.
Kind regards
Jeffrey
JV
January 5, 2006 at 2:16 am
Rolling back a transaction does not mean a query should not complete. A rollback does not implicitly mean a failure occured, it just says that for some reason someone decided that an action should be undone. After that it is still possible to do further work, so raising an error would not be good.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply