Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 nested transactions in sql server 2008

Author  Topic 

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-09-25 : 09:03:22
how to write nested transactions in sql server 2008 please explain with simple example

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-09-25 : 12:24:00
SQL Server does not support nested transactions.
http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2630-nested-transactions-are-real/


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -