To illustrate this, let s start from the simplest database example. I ll first create a database transaction. The SQL description of it will then be translated to an MTS-style transaction. In this situation, the MTS-based description can be thought of as another language to describe the same activity. If you don t already have an understanding of the basic concepts of databases, such as DDL, ER-diagrams, and transactions, plus knowledge of the Windows DNA architecture and MTS, you should look into these a bit before you continue with this article.
Components Consider the following scenario.
Assume that I have tables A, B, and C as shown in Figure 1 . B. By wrapping the insert statements in a transaction, each insert can be observed before the work is committed. If the transaction is terminated, the stored procedure ensures that all those modifications are rolled back. Otherwise, the stored procedure ensures that all modifications within the transaction are committed. Thus, it must have the transactional attribute Requires a Transaction or Requires a New Transaction.