Switch Off ROLLBACK?

Last Post 30 Apr 2002 05:27 AM by TomPullen. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Irish
New Member
New Member

--
29 Apr 2002 11:41 PM
I'm developing a system, and periodically I'm wanting to stop the code.
Instead of having to wait for roll back to finish, is it possible to switch the facility off?

I've checked the manuals and don't seem to see any info. regarding that option...

Thanks,
David.
TomPullen
New Member
New Member

--
30 Apr 2002 05:27 AM
No you can't turn off transaction logging/rollback. The only situation it's avoided in is BULK INSERT. If you just want to check queries work/see execution plans, use the NOEXEC option.
You are not authorized to post a reply.

Acceptable Use Policy