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 an index in a database?

979

What is data block and how to define data block size?

1026

What are triggers? How do you invoke a trigger on demand?

1318

What is dml command?

969

What is the maximum length of an alert name?

1001

How global temporary tables are represented and its scope?

977

What is the meaning of resultset type_scroll_insensitive?

956

Write an SQL query to obtain the 2nd highest salary.

1078

What is the data type of time?

963

What is it unwise to create wide clustered index keys?

1007

How can I check if a view exists in a sql server database?

1038

How you would rewrite the sql query to return the customerid sorted numerically?

998

What is use of dbcc commands?

1072

Define primary key?

1138

Explain alternate key, candidate key and composite key in sql server?

915