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

Explain about an event-driven programming language?

731


How many tabs in a tabbed dialog do you consider appropriate?

1880


What is the Windows API?

1217


How do I dial a phone number without using the MSCOMM VBX?

1484


What is the use of Hyperlink control for DHTML applications?

1610


How would you create Visual basic Document file?

1634


Explain Default cursor Type and LockEdits type in RDO?

1679


Difference between ActiveX Control and Standard Control.

2377


What is recordset in visual basic?

772


Is there any way to pass a variable to a form apart from using global variables?

1293


What is Parser Bug?

2090


What is file in vb?

679


What is the use of ActiveX Documents?

1785


Can you create a updatecascade, Deletecascade relation in Ms- Access? If no, give on eample.

1308


How would you add elements in TreevieW Control?

1739