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

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

930

How many types of attribute relationships are there? : sql server analysis services, ssas

1059

What is 4nf in normalization form?

1013

What are dml triggers and types of dml triggers?

970

What is the purpose of data source?

1025

How to run queries with sql server management studio express?

1076

What is the difference between dbcc indexdefrag and dbcc reindex?

976

How many primary keys are possible in a table?

918

Tell me what is difference between view and materialized view?

927

Is sql server 2016 free?

918

Can sql server 2016 run on windows 7?

908

How to encrypt Strored Procedure in SQL SERVER?

1152

Explain the difference between function and stored procedure?

930

What is snapshot replication?

1042

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109