Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How many nested transaction can possible in sql server?

Question Posted / kin

Answers were Sorted based on User's Feedback



How many nested transaction can possible in sql server?..

Answer / 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

How many nested transaction can possible in sql server?..

Answer / naveen

32 nested transaction can possible in sql server

Is This Answer Correct ?    14 Yes 4 No

How many nested transaction can possible in sql server?..

Answer / naveen singh

three type of

(1)Begin
(2)Rollback
(3)commit

Is This Answer Correct ?    11 Yes 25 No

Post New Answer

More SQL Server Interview Questions

Explain transaction server auto commit?

0 Answers  

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

How many types of functions are there in sql server?

0 Answers  

what is a cursor and what is its use?

2 Answers   L&T,

what is datawarehouse?

0 Answers   Informatica,




How to search for a string in all stored procedure in sql server?

0 Answers  

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

what is statistics

1 Answers  

What are the different editions available in sql server 2000?

0 Answers  

Can you explain various data region available in ssrs with their use?

0 Answers  

How to encrypt data between dialogs?

0 Answers  

What are data files?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories