What are Benefits of wrapping database calls into MTS transactions?
If database calls are made within the context of a transaction, aborting the transaction will undo and changes that occur within that transaction. This removes the possibility of stranded, or partial data. Transaction that uses the Microsoft Transaction Server (MTS) environment. MSMQ implicitly uses the current MTS transaction if one is available. BENIFTIS OF USING MTS : Database Pooling, Transactional operations, Deployment, Security, Remote Execution This allows MTS to reuse database connections. Database connections are put to ?sleep? As opposed to being created and destroyed and are activated upon request.
