phil.wood 94423 (9/14/2010)
Oops, I got it wrong.In my defence, nesting works all over Microsoft so I'm a little surprised they never got it working here. Almost seems like an oversight.
Would have made more sense if they had employed a slightly different keyword such as e.g.
ROLLBACK TRAN ALL
or
ROLLBACK TRANSACTIONS
Just my view 🙂
Nesting does work with transactions. It's just that if you use rollback transaction, then all open transactions are rolled back. If you commit a transaction, then only the innermost transaction is committed.
If you really want full nesting, you can use checkpointing in your transactions and use named transactions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP