暂时无法在支持网站上提交享有定期维护的产品表单。 如果您需要我们立即提供帮助,请与技术支持部门联系。 对于由此给您带来的不便,我们深表歉意。
获得即时帮助
完成注册
登录
请求定价
联系销售人员
您已选择一个产品捆绑包。 您能否选择单个产品以便我们更好地满足您的请求。 *
技术支持工程师目前正忙,无法回应您的消息。 如果需要即时服务,请通过我们的服务请求表提交请求。
以下文章可根据您的描述解决您的问题。
The SQL Transactions Event facility contains event classes that can be used to monitor the status of transactions. The event class names prefixed with TM: are used to track the transaction-related operations that are sent through the transmission management interface.
DTCTransaction – Close Connection
Created when Distributed Transaction Coordinator state is Close Connection.
Medium
DTCTransaction – Creating a New DTC Transaction
Created when Distributed Transaction Coordinator state is Creating A New DTC Transaction.
DTCTransaction – Enlisting in a DTC Transaction
Created when Distributed Transaction Coordinator state is Enlisting in A DTC Transaction.
DTCTransaction – Get Address
Created when Distributed Transaction Coordinator state is Get Address.
DTCTransaction – Internal Abort
Created when Distributed Transaction Coordinator state is Internal Abort.
DTCTransaction - Internal Active
Created when Distributed Transaction Coordinator state is Internal Active.
DTCTransaction – Internal Commit
Created when Distributed Transaction Coordinator state is Internal Commit.
DTCTransaction – Preparing Transaction
Created when Distributed Transaction Coordinator state is Preparing Transaction.
DTCTransaction – Propagate Transaction
Created when Distributed Transaction Coordinator state is Propagate Transaction.
DTCTransaction – TM Failed While In Prepared State
Created when Distributed Transaction Coordinator state is TM Failed While in Prepared State.
DTCTransaction – Transaction Is Aborting
Created when Distributed Transaction Coordinator state is Transaction is Aborting.
DTCTransaction – Transaction Is Committing
Created when Distributed Transaction Coordinator state is Transaction is Committing.
DTCTransaction – Transaction Is Prepared
Created when Distributed Transaction Coordinator state is Transaction is Prepared.
DTCTransaction – Unknown
Created when Distributed Transaction Coordinator state is Unknown.
SQLTransaction Begin
Created when a SQL transaction has begun. (Disabled by default)
SQLTransaction Commit
Created when a SQL transaction is committed. (Disabled by default)
SQLTransaction Rollback
Created when a SQL transaction is rolled back. (Disabled by default)
SQLTransaction Savepoint
Created when a SQL transaction is at savepoint. (Disabled by default)
TM: Begin Tran Completed
Created when a BEGIN TRANSACTION request has been completed.
TM: Begin Tran Starting
Created when a BEGIN TRANSACTION request is starting.
TM: Commit Tran Completed – Commit
Created when a COMMIT TRANSACTION request is completed.
TM: Commit Tran Completed – Commit and Begin
Created when a COMMIT TRANSACTION request is completed and a new transaction will be started after the current transaction is committed.
TM: Commit Tran Starting – Commit
Created when a COMMIT TRANSACTION request is starting.
TM: Commit Tran Starting – Commit and Begin
Created when a COMMIT TRANSACTION request is starting and a new transaction will be started after the current transaction is committed.
TM: Promote Tran Completed
Created when a PROMOTE TRANSACTION request has completed.
TM: Promote Tran Starting
Created when a PROMOTE TRANSACTION request is starting.
TM: Rollback Tran Completed – Rollback
Created when a ROLLBACK TRANSACTION request has completed.
TM: Rollback Tran Completed – Rollback and Begin
Created when a ROLLBACK TRANSACTION request has completed and a new transaction will be started after the current transaction is rolled back.
TM: Rollback Tran Starting – Rollback
Created when a ROLLBACK TRANSACTION request is starting.
TM: Rollback Tran Starting – Rollback and Begin
Created when a ROLLBACK TRANSACTION request is starting and a new transaction will be started after the current transaction is rolled back.
TM:Save Tran Completed
Created when a SAVE TRANSACTION request has completed.
TM:Save Tran Starting
Created when a SAVE TRANSACTION request has started.
TransactionLog
Created when a Transaction log activity has occurred. (Disabled by default)
The SQL TSQL Event facility contains general TSQL events.
Exec Prepared SQL
Created when the SqlClient, ODBC, OLEDB, or D-Library has executed a prepared Transact-SQL statement or statements. (Disabled by default)
Prepare SQL
Created when the SqlClient, ODBC, OLEDB, or D-Library has prepared a Transact-SQL statement or statements for use. (Disabled by default)
SQL:BatchCompleted
Created when a Transact-SQL batch has completed. (Disabled by default)
SQL:BatchStarting
Created when a Transact-SQL batch is starting. (Disabled by default)
SQL:StmtCompleted
Created when a Transact-SQL statement has completed. (Disabled by default)
SQL:StmtRecompile – Browse Permissions Changed
Created when statement-level recompilations occurred for browse permission changes.
SQL:StmtRecompile – Cursor Options Changed
Created when statement-level recompilations occurred for cursor options changes.
SQL:StmtRecompile – Deferred Compile
Created when statement-level recompilations occurred for deferred compiles. (Disabled by default)
SQL:StmtRecompile – Options Requested
Created when statement-level recompilations occurred for options (recompile) requests.
SQL:StmtRecompile – Partition View Changed
Created when statement-level recompilations occurred for partition view changes.
SQL:StmtRecompile – Query Notification Environment Changed
Created when statement-level recompilations occurred for query notification environment changed.
SQL:StmtRecompile – Remote Rowset Changed
Created when statement-level recompilations occurred for remote rowset changes.
SQL:StmtRecompile – Schema Changed
Created when statement-level recompilations occurred for schema changes.
SQL:StmtRecompile – Set Option Changed
Created when statement-level recompilations occurred for set option changes. (Disabled by default)
SQL:StmtRecompile – Statistics Changed
Created when statement-level recompilations occurred for statistics changes. (Disabled by default)
SQL:StmtRecompile – Temp Table Changed
Created when statement-level recompilations occurred for temp table changes.
SQL:StmtStarting
Created when a Transact-SQL statement has started. (Disabled by default)
Unprepare SQL
Created when the SqlClient, ODBC, OLEDB, or DB-Library has unprepared (deleted) a prepared Transact-SQL statement or statements. (Disabled by default)
XQuery Static Type
Created when the SQL Server® executed an XQuery expression. (Disabled by default)
Use the SQL User-Configurable Event facility to monitor user-defined events that cannot be audited by the system-supplied event classes in the other SQL facilities.
User-Configurable-0
Created when User-Configurable event 0 occurs.
User-Configurable-1
Created when User-Configurable event 1 occurs.
User-Configurable-2
Created when User-Configurable event 2 occurs.
User-Configurable-3
Created when User-Configurable event 3 occurs.
User-Configurable-4
Created when User-Configurable event 4 occurs.
User-Configurable-5
Created when User-Configurable event 5 occurs.
User-Configurable-6
Created when User-Configurable event 6 occurs.
User-Configurable-7
Created when User-Configurable event 7 occurs.
User-Configurable-8
Created when User-Configurable event 8 occurs.
User-Configurable-9
Created when User-Configurable event 9 occurs.
The SQL Data Level facility contains event classes that are used to monitor SQL data changes.
Row added to a table
Created when a row has been added to a table.
High
Row updated in a table
Created when a row has been updated in a table.
Row removed from a table
Created when a row has been deleted from a table.
Table added
Created when a table has been added to a database.
Table removed
Created when a table has been deleted from a database.
Table altered
Created when a database table has been altered.
Table truncated
Created when a table has been truncated in a database.
View added
Created when a view is added to a database.
View removed
Created when a view has been deleted from a database.
View altered
Created when a database view has been altered.
Procedure added
Created when a procedure has been added to a database.
Procedure removed
Procedure altered
Created when a database procedure has been altered.
Function added
Created when a function table has been added to a database.
Function removed
Created when a function has been deleted from a database.
Function altered
Created when a database function has been altered.
Index added to a table
Created when an index has been added to a table.
Index removed from a table
Created when an index has been deleted from a table.
Trigger added
Created when a trigger has been added.
Trigger removed
Created when a trigger has been deleted.
Trigger altered
Created when a table trigger has been altered.
Rule added
Created when a rule has been added to a database.
Rule removed
Created when a rule has been deleted from a database.
Object renamed
Created when a database object has been renamed.
Primary key added to a table
Created when a primary key has been added to a table.
Primary key removed from a table
Created when a primary key has been deleted from a table.
Foreign key added to a table
Created when a foreign key has been added to a table.
Foreign key removed from a table
Created when a foreign key has been deleted from a table.
Default object added
Created when a default object has been added to a database.
Default object removed
Created when a default object has been deleted from a database.
Default constraint added to a table
Created when a default constraint has been added to a table.
Default constraint removed from a table
Created when a default constraint has been deleted from a table.
Check constraint added to a table
Created when a check constraint has been added to a table.
Check constraint removed from a table
Created when a check constraint has been deleted from a table.
Type added
Created when a type has been added to a database.
Type removed
Created when a type has been deleted from a database.
Statistics added to a table
Created when statistics have been added to a table.
Statistics removed from a table
Created when statistics have been deleted from a table.
User added
Created when a user has been added to a database.
User removed
Created when a user has been removed from a database.
您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”,转至适用于*产品*的正确支持内容和帮助。
The document was helpful.
选择评级
I easily found the information I needed.
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
Quest Software门户不再支持IE 8、9和10,建议将您的浏览器升级到最新版本的Internet Explorer或Chrome。
要升级到IE 11,请单击此处
要升级到Chrome,请单击此处
如果继续使用IE 8、9和10,您将无法充分利用我们所有出色的自助服务功能。