How many nested transaction can possible in sql server?

Answers were Sorted based on User's Feedback



How many nested transaction can possible in sql server?..

Answer / raj..

There is a limit of 32 on the maximum nested levels on both
SQL Server 2000 and 2005

Is This Answer Correct ?    27 Yes 2 No

How many nested transaction can possible in sql server?..

Answer / naveen

32 nested transaction can possible in sql server

Is This Answer Correct ?    14 Yes 4 No

How many nested transaction can possible in sql server?..

Answer / naveen singh

three type of

(1)Begin
(2)Rollback
(3)commit

Is This Answer Correct ?    11 Yes 25 No

Post New Answer

More SQL Server Interview Questions

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,


How to create a simple stored procedure in ms sql server?

0 Answers  


select names starts with a,b,c

8 Answers   Scope International,


Explain view in sql server?

0 Answers  


What is the purpose of indexing?

0 Answers  






what is the main difference between after trigger and instead trigger.

2 Answers  


What is a raid and what are different types of raid configurations?

0 Answers  


What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,


What is a database in ms sql server?

0 Answers  


Why de-normalization required?

0 Answers  


How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  


What is Command line parameters in PLSQL.?

0 Answers   MCN Solutions,


Categories