Top "Nested-transactions" questions

SAVE TRANSACTION vs BEGIN TRANSACTION (SQL Server) how to nest transactions nicely

I have a stored procedure that needs to set a save point so that it can, under certain circumstances, undo …

sql-server transactions nested-transactions
EJB 3.0 - Nested Transaction != Requires New?

I just read the Transactions Chapter (10) of "Mastering EJB 3.0" and now I'm confused about nested transactions. The book says "The …

jakarta-ee transactions ejb-3.0 nested-transactions
SQL Server 2005: Why Name Transactions?

I've been sorting out the whole nested transaction thing in SQL server, and I've gleamed these nuggets of understanding of …

sql-server transactions nested-transactions
Check if an existing transactionscope is active

I am using: public class TransactionUtils { public static TransactionScope CreateTransactionScope() { var TransactionOptions = new TransactionOptions(); TransactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; …

c# transactions transactionscope nested-transactions
how to manage nested transaction with try catch

--Drop Table Tab1 Begin Transaction TR1; Save Transaction TR1; Create Table Tab1(f1 decimal(10,0)); Begin Transaction TR2 Save Transaction TR2 …

sql-server try-catch sqltransaction savepoints nested-transactions
Purpose of nested transactions

I have never understood what a nested transaction is good for. Committing a nested transaction commits nothing - it just …

sql-server database transactions nested-transactions