Can you have a nested transaction?

Answer Posted / ram&saran

It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

161


What is key set driven?

539


How network traffic be reduced by using the stored procedure?

580


How to connect sql server management studio express to sql server 2005 express?

579


What is a derived table?

509






how you can get the list of largest tables in a database? : Sql server administration

548


Why use sub query in sql server and list out types of sub queries?

539


Explain mixed authentication mode of sql server?

541


What stored procedure would you use to view lock information?

523


What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

557


Explain how to use linked server?

561


What are dml triggers and types of dml triggers?

547


What are the different SQL Server Versions you have worked on?

550


Why do you need a sql server?

502


How to check status of stored procedure in sql server?

443