Can you have a nested transaction?

Answer Posted / swapna

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

647


how you can configure a running aggregate in SSRS?

112


What is serializable?

664


What is change data capture (cdc) in sql server 2008?

564


If no size is defined while creating the database, what size will the database have?

544






What are the 10 characteristics of data quality?

527


How do you use a subquery to find records that exist in one table and do not exist in another?

546


Can we use where clause in union?

593


How to find the login name linked to a given user name?

528


Do you know sql server 2008 backup compression?

564


How many types of triggers in sql server?

521


Why use update_statistics command in sql server?

549


What is difference between oltp and olap?

572


What command is used to create a database in the sql server and how?

600


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

547