You have two different application sessions. What solution should you implement to share transactions and lock between them to avoid any conflicts

You have two different application sessions. What solution should you implement to share transactions and lock between them to avoid any conflicts

You have two different application sessions. What solution should you implement to share transactions and lock between them to avoid any conflicts

A.
SET REMOTE_PROC_TRANSACTIONS ON

B.
Use BEGIN DISTRIBUTED TRANSACTION in the stored procedure.

C.
Use Bound sessions

D.
Use unBound sessions

Explanation:
http://msdn.microsoft.com/en-us/library/ms177480.aspx

Bound sessions ease the coordination of actions across multiple sessions on the same server. Bound sessions allow two or more sessions to share the same transaction and locks, and can work on the same data without lock conflicts. Bound sessions can be created from multiple sessions within the same application or from multiple applications with separate sessions.



Leave a Reply 0

Your email address will not be published. Required fields are marked *