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


Please Help Members By Posting Answers For Below Questions

How to control the file?

617


What is ado in vb?

519


How many ways we can access file using VB?

1616


Is it possible to Manipulate data through flexgrid? Explain.

2068


How should dates be implemented so they work with other language and country formats?

957






what is the Difference between Recordset and Querydef?

1863


How many ways you can access file using VB?

579


What are the properties of datacontrol?

1529


How would you map properties to controls by using ActiveX Control Interface Wizard?

1412


How many objects resides in ADO ?

1513


what is the Difference between Tabletype and Snapshot?

1532


How many objects resides in ADO ?

1455


What is Seek Method which type of record set is available this?

1506


How can Visual Basic be used for server-side scripting?

543


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

1405