yes, we can have nested transactions. to know the nest level use @@tranco

Can you have a nested transaction?

Question Posted / visala

Answer Posted / visala

yes, we can have nested transactions. to know the nest
level use @@trancount

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you delete a trigger?

952

How to filter records of table in SQL SERVER?

1060

Can binary strings be converted into numeric or float data types?

1006

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1014

What does REVERT do in SQL Server 2005?

943

What is sql server replication? : sql server replication

960

Do you know the different ddl commands in sql?

1035

What is database replication? What are the different types of replication you can set up in sql server?

945

What are the 2 types of classifications of constraints in the sql server?

1100

How to delete an existing row with delete statements in ms sql server?

1068

What is triggers and stored procedures?

925

What is the difference between osql and query analyzer?

972

How to defragment indexes with alter index ... Reorganize?

1060

How to change the data type of an existing column with "alter table" statements in ms sql server?

970

Can you explain about buffer cash and log cache in sql server?

931