Export (0) Print
Expand All

Transactions Event Classes

SQL Server 2000

Transactions Event Classes

The following table describes the Transactions event classes in the Transactions event category.

Event class Description
DTCTransaction Tracks Microsoft® Distributed Transaction Coordinator (MS DTC) coordinated transactions between two or more databases.
SQLTransaction Tracks Transact-SQL BEGIN, COMMIT, SAVE, and ROLLBACK TRANSACTION statements.
TransactionLog Tracks when transactions are written to the transaction log.

Use the DTCTransaction event class to monitor the state of MS DTC transactions as they occur. This can be useful when testing an application that uses distributed transactions.

Monitor the SQLTransaction event class when testing your application stored procedures or triggers to determine, for example, when transactions are committed or rolled back.

Use the TransactionLog event class when you want to monitor activity in the Microsoft SQL Server™ transaction log, for example, to test your application and determine the types of logging activity.

See Also

Transactions Event Category

Transactions Data Columns

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft