Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Reg : Help on Transactions in SQL Expand / Collapse
Posted Monday, September 23, 2013 11:49 PM


Group: General Forum Members
Last Login: Monday, July 6, 2015 1:28 AM
Points: 188, Visits: 516
Hi There,

I have some doubts on transactions. Following is my problem & I'm intended to go with transactions .

I have a stored procedure. If it ran successfully then no problem, in case of any interruption like killing the SP or some error occurred while in the middle of the run then I have to rollback all the things which was done by sp so far.

So I'm intended to go with transactions .

If I create transaction it will make the roll back easy to me.

1. I need code which will automatically rollback when any error while in the run of whole
2. What would happen if the sp killed forcibly .i.e., will transaction commuted or rolled back ?

Thanks in Advance
Post #1497656
Posted Tuesday, September 24, 2013 8:07 AM



Group: General Forum Members
Last Login: Yesterday @ 8:08 PM
Points: 16,145, Visits: 16,850
Look at try/catch.


Need help? Help us help you.

Read the article at for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1497877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse