what is the Benefit of wrapping database calls into MTS
transactions?



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

Post New Answer

More Visual Basic Interview Questions

How can you filter out specific type of file using file system controls?

0 Answers  


What is the return type of Instr and Strcmp?

3 Answers  


How would you add elements and pictures to listitems in listview control?

0 Answers  


Explain about manipulating the recordset object

0 Answers  


What is Parser Bug?

0 Answers  






Write the steps in Creating ActiveX Dll and Active Exe?

0 Answers  


Difference between Linked Object and Embedded Object?

2 Answers  


Default cursor Type and LockEdit type in DAO?

1 Answers  


what is the Difference between Query unload and unload in form?

1 Answers  


How do I create controls dynamically (at run-time)?

0 Answers  


How to control the file?

0 Answers  


How does the following statements work? On Error Goto Err_Handler

2 Answers  


Categories