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

what is bit datatype? : Sql server database administration

959

What is open database communication (odbc)?

1109

How to create nested stored procedure?

1071

what is a traditional network library for sql servers? : Sql server database administration

1009

What is conditional split?

1134

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

1025

How to use union to merge outputs from two queries together in ms sql server?

1131

What do we need queues in sql service broker?

1116

Define left outer join in sql server joins?

1008

How ssrs maintain security?

1132

How to test subquery results with the exists operator?

1163

what type of index will get created after executing the above statement? : Sql server database administration

1026

What is read committed?

1167

What is difference statement and preparedstatement?

1030

Can foreign key be deleted?

975