what is the Benefit of wrapping database calls into MTS
transactions?
Answer / guest
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.
Is This Answer Correct ? | 0 Yes | 0 No |
How can you filter out specific type of file using file system controls?
What is the return type of Instr and Strcmp?
How would you add elements and pictures to listitems in listview control?
Explain about manipulating the recordset object
What is Parser Bug?
Write the steps in Creating ActiveX Dll and Active Exe?
Difference between Linked Object and Embedded Object?
Default cursor Type and LockEdit type in DAO?
what is the Difference between Query unload and unload in form?
How do I create controls dynamically (at run-time)?
How to control the file?
How does the following statements work? On Error Goto Err_Handler