It's possible, up to 32 levels of transaction in sql server2005. begi

Can you have a nested transaction?

Question Posted / ram&saran

4 Answers
11956 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / ram&saran

It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is b tree index?

921

What is the difference between ddl and dml?

1060

What is amo? : sql server analysis services, ssas

1097

How many types of built in functions are there in sql server 2012?

928

how we use window authentication connection with sql server.?

1163

How to set database to be read_only in ms sql server?

1017

What is table valued function and scalar valued functions?

1098

How many types of local tables are there in sql server?

937

What is role playing dimension with two examples? : sql server analysis services, ssas

1014

How do you create an execution plan?

958

can a database be shrunk with users active? : Sql server administration

1020

What is sql collation?

1220

What is ems sql management studio? : sql server management studio

1116

What is the function of inner join?

1080

How to return the top 5 rows from a select query in ms sql server?

1152