Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
라이브 도움말 보기
등록 완료
로그인
가격 산정 요청
영업 담당자에게 문의
제품 번들을 선택했습니다. 귀하의 요청에 더 적합한 서비스를 제공해 드릴 수 있도록 개별 제품을 선택해 주십시오. *
지금은 채팅에 회신할 수 있는 기술 지원 엔지니어가 없습니다. 즉각적인 서비스를 받으려면 당사의 서비스 요청 양식을 사용하여 요청을 제출하십시오.
다음 문서의 설명에 따라 문제를 해결할 수 있습니다.
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.
계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.
The document was helpful.
평가 결과 선택
I easily found the information I needed.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center
Quest Software 포털은 더 이상 IE 8, 9, 10을 지원하지 않습니다. 브라우저를 최신 버전의 Internet Explorer나 Chrome으로 업그레이드하는 것이 좋습니다.
IE 11로 업그레이드 여기를 클릭
Chrome으로 업그레이드 여기를 클릭
IE 8, 9 또는 10을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
