How many nested transaction can possible in sql server?

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

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  


What happens if null values are involved in string operations?

0 Answers  


What is index fragmentation in ms sql server?

0 Answers  


What are the type of joins? When do we use Outer and Self joins?

3 Answers  


What are the different types of queries?

1 Answers  






What do you need to connect php to sql server?

0 Answers  


What is use of except clause? How it differs from not in clause?

0 Answers  


Define left outer join in sql server joins?

0 Answers  


How to create prepared statements using odbc_prepare()?

0 Answers  


What is replication and database mirroring?

0 Answers  


What are the difference between clustered and a non-clustered index?

0 Answers  


What is the difference between join and inner join?

0 Answers  


Categories