How many nested transaction can possible in sql server?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is spatial nonclustered index

720


Can we hide the definition of a stored procedure from a use?

870


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

694


How to create prepared statements using odbc_prepare()?

778


Which are ddl commands?

708






What happens to a statement batch if there is a compilation error?

698


Differentiate sql server reporting services vs. Crystal reports?

166


What are the properties of the transaction?

739


What is the recursive stored procedure in sql server?

710


How to start and end transact-sql statements?

747


If the job running very slow what is the action you do

1601


Can I use sql azure as a backup with log shipping or database mirroring?

148


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

683


What is the security principal at the server level that represents your session?

782


How to configure odbc dsn with different port numbers?

756