what is the Benefit of wrapping database calls into MTS
transactions?
Answer Posted / 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 |
Post New Answer View All Answers
Explain about an event-driven programming language?
How many tabs in a tabbed dialog do you consider appropriate?
What is the Windows API?
How do I dial a phone number without using the MSCOMM VBX?
What is the use of Hyperlink control for DHTML applications?
How would you create Visual basic Document file?
Explain Default cursor Type and LockEdits type in RDO?
Difference between ActiveX Control and Standard Control.
What is recordset in visual basic?
Is there any way to pass a variable to a form apart from using global variables?
What is Parser Bug?
What is file in vb?
What is the use of ActiveX Documents?
Can you create a updatecascade, Deletecascade relation in Ms- Access? If no, give on eample.
How would you add elements in TreevieW Control?