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 are the difference between data mart and data warehouse? : sql server analysis services, ssas

954

What is key attribute?

924

How many types of local tables are there in sql server?

918

How to transfer an existing table from one schema to another schema in ms sql server?

972

What's the information that can be stored inside a bit column?

990

When do you think a developer should use sql server-based cursors?

1037

How to replace given values with null using nullif()?

980

What is difference between views and stored procedures?

977

What is a primary index?

919

Is it possible to call a stored procedure within a stored procedure?

953

How to loop through result set objects using odbc_fetch_row()?

963

What is an indexing strategy?

997

Would you store your query in a ssrs report or a database server? State the reason why?

152

Mention the different types of triggers?

1099

How do triggers work?

922