There is a limit of 32 on the maximum nested levels on both SQL Server 20

How many nested transaction can possible in sql server?

Question Posted / raj..

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to write a query with a left outer join in ms sql server?

924

How to reaname table name without using sp_Rename in sql server..?

935

How real and float literal values are rounded?

1094

What are the differences between stored procedure and the dynamic sql?

1022

A trigger can reference objects outside the current database? State true or false.

942

How can we get count of the number of records in a table?

898

What guidelines should be followed to help minimize deadlocks?

868

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1011

What is dirty page?

918

What is the process of normalization?

1046

What do you mean by 'normalization'?

1001

How many types of attribute relationships are there? : sql server analysis services, ssas

999

What are the steps you can take to avoid “deadlocks”?

918

What is executereader?

894

What is the difference between DataRow.Delete() and DataRow.Remove()?

1164