How many nested transaction can possible in sql server?

Answer Posted / naveen

32 nested transaction can possible in sql server

Is This Answer Correct ?    14 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between control flow and data flow?

612


What is named query? : sql server analysis services, ssas

599


What are the advantages of passing name-value pairs as parameters?

741


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1727


what are triggers? : Sql server database administration

572






what is hash nonclustered index

624


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1569


What are transactions and its controls?

702


How to create a store procedure with encryption?

600


What are orphan records?

622


How to connect a database with sql express.?

665


How to enable tcp/ip protocol on a sql server?

674


Explain the microsoft sql server delete command?

620


What are the advantages dts has over bcp?

625


What is difference between cte and view?

605