No announcements
Found 91744 threads
-
1 VotesROLLBACK TRANSACTION
1 - You will rollback the transaction in case of an error, for example.Answered | 2 Replies | 7511 Views | Created by motevallizadeh - Sunday, September 6, 2009 10:25 AM | Last reply by Hunchback - Sunday, September 6, 2009 3:41 PM
-
1 Votes
Rollback Transaction
BOL: "Rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint inside the transaction.Answered | 1 Replies | 844 Views | Created by Surbakti - Monday, October 28, 2013 10:52 AM | Last reply by Kalman Toth - Monday, October 28, 2013 11:07 AM -
1 Votes
rollback transaction
Under transactions you'll see something called TransactionOption.Answered | 3 Replies | 3561 Views | Created by TruncatedHype - Friday, June 15, 2012 10:03 PM | Last reply by plditallo - Saturday, June 16, 2012 7:40 PM -
0 Votes
Rollback transaction
> If one transaction fails to insert i want to rollback entire block, i don't want to insert any of the records to table To achieve your requirement, you can ...Answered | 2 Replies | 649 Views | Created by StephenTONY - Tuesday, January 30, 2018 2:53 PM | Last reply by Hannah Yu - Wednesday, January 31, 2018 6:27 AM -
0 Votes
Transaction rollback
You have 2 ways a) Transactions via C#Answered | 5 Replies | 1843 Views | Created by Debra has a question - Monday, April 11, 2016 7:21 PM | Last reply by Naomi N - Tuesday, April 12, 2016 3:58 PM -
1 Votes
Rollback in Atomic Transaction scope
The atomic scope will roll back your inserts of records to the database, only if it had happened within a DTC (distibuted transaction coordinator) transaction.Answered | 2 Replies | 2555 Views | Created by Sharmishtha - Tuesday, December 13, 2011 2:18 PM | Last reply by Shay Feldman - Tuesday, December 13, 2011 2:43 PM -
0 Votes
Transaction rollback call failed
Thanks for reply, but there seems to be a problem when I applied this pattern, the rollback call causes exception because the transaction is no long valid at that point when the ...Answered | 2 Replies | 5568 Views | Created by petarch - Monday, November 15, 2010 11:19 AM | Last reply by petarch - Saturday, November 20, 2010 3:32 AM -
1 Votes
Rollback a transaction in another session
Hi Guys, Is there a way to rollback an active transaction running in another session without killing the process.Answered | 3 Replies | 585 Views | Created by lilutchay - Thursday, July 26, 2018 11:04 PM | Last reply by Shanky_621 - Friday, July 27, 2018 6:47 AM -
0 Votes
ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
SSIS has its own implementation for transactions that you should ...Answered | 2 Replies | 7377 Views | Created by volyn - Monday, February 27, 2012 4:47 PM | Last reply by blastoSO - Wednesday, November 13, 2013 11:08 PM -
0 Votes
rollback transaction Help
First scenario: it can take place when data that has been updated by one transaction (Transaction A), overwritten by another transaction (Transaction B), ...Answered | 6 Replies | 2234 Views | Created by emmim44 - Monday, November 5, 2012 2:22 PM | Last reply by Kuldeep Bisht - Tuesday, November 6, 2012 11:40 AM -
1 Votes
transaction does not rollback
Some errors abort the batch and rolls back the transaction.Answered | 5 Replies | 4288 Views | Created by Corey Furman - Monday, October 4, 2010 7:11 PM | Last reply by Corey Furman - Monday, October 4, 2010 8:44 PM -
1 Votes
Transaction rollback on connection failure or timeout
Yes, SQL Server will rollback if the connection is lost.Answered | 1 Replies | 4609 Views | Created by Navaneeth Adruguli - Thursday, November 8, 2012 8:13 AM | Last reply by TiborK - Thursday, November 8, 2012 8:16 AM -
0 Votes
commit inner transaction but rollback outer
Ramunas This is not possible, the way begin tran .. commit .. rollback work is .. each time Begin tran is executed tran count is incremented by 1 and each time commit is ...Answered | 5 Replies | 7730 Views | Created by Ramunas.Balukonis - Friday, September 21, 2012 5:59 AM | Last reply by SimpleSQL - Friday, September 21, 2012 7:12 AM -
1 Votes
Nested transactions in internal SP - RollBack
The only way to partially rollback a transaction is to ROLLBACK to a Savepoint established with SAVE TRANSACTION.Answered | 7 Replies | 1410 Views | Created by MSMarreddy - Friday, March 7, 2014 10:31 AM | Last reply by Erland Sommarskog - Saturday, March 8, 2014 8:56 PM -
0 Votes
Commite transaction or rollback it
Using TRY…CATCH in a transaction The following example shows how a TRY…CATCH block works inside a transaction.Answered | 1 Replies | 3353 Views | Created by Aboudeh - Friday, July 8, 2011 3:42 PM | Last reply by gao.seng - Friday, July 8, 2011 3:54 PM -
0 Votes
how to use @@erro to rollback transactions
Something like: begin transaction; update ...Answered | 1 Replies | 5063 Views | Created by Leonardo A L Ferreira - Monday, March 2, 2009 1:39 PM | Last reply by Hunchback - Monday, March 2, 2009 1:57 PM -
0 Votes
ROLLBACK TRANSACTION in a stored procedure
I want to apply ROLLBACK TRANSACTION when STEP 1 is not performed to restrict STEP 2.Answered | 3 Replies | 738 Views | Created by Vamshi K J - Wednesday, October 9, 2019 5:01 AM | Last reply by Erland Sommarskog - Wednesday, October 9, 2019 9:52 PM -
0 Votes
Rollback Transaction Issue
I recommend against using transaction names.Answered | 1 Replies | 714 Views | Created by eran.m - Tuesday, December 16, 2014 6:47 PM | Last reply by Erland Sommarskog - Tuesday, December 16, 2014 11:17 PM -
0 Votes
Commit sub transaction and still rollback the overall transaction except for the sub transaction
Then, if any procedure needs to do a ROLLBACK, the procedure would first insert into a table variable all the rows (if any) in the error log for the current ...Answered | 6 Replies | 3346 Views | Created by moondaddyx - Tuesday, July 10, 2012 5:35 PM | Last reply by Erland Sommarskog - Saturday, July 14, 2012 8:50 PM -
0 Votes
SSMA 5.2 - Rollback Transaction SSMA$ROLLBACK_TRIGGER$SP
Hi, Rollback transaction is used to simulate rollback trigger in Sybase.Answered | 2 Replies | 8130 Views | Created by Vijayaraghavk - Wednesday, February 8, 2012 6:07 PM | Last reply by Vijayaraghavk - Wednesday, March 7, 2012 7:16 PM - Items 1 to 20 of 91744 Next ›
No announcements
