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
Explain the difference between control flow and data flow?
What is named query? : sql server analysis services, ssas
What are the advantages of passing name-value pairs as parameters?
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?
what are triggers? : Sql server database administration
what is hash nonclustered index
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What are transactions and its controls?
How to create a store procedure with encryption?
What are orphan records?
How to connect a database with sql express.?
How to enable tcp/ip protocol on a sql server?
Explain the microsoft sql server delete command?
What are the advantages dts has over bcp?
What is difference between cte and view?