Chat now with support
Chat with Support

Change Auditor for SQL Server 7.1.1 - Event Reference Guide

SQL Full Text Event

The SQL Full Text Event facility contains general full-text events.

FT: Crawl Aborted

Created when an error exception has been encountered during a full-text crawl.

Medium

FT: Crawl Started

Created when a full-text crawl has started.

Medium

FT: Crawl Stopped

Created when a full-text crawl has stopped.

Medium

SQL Locks Event

The SQL Locks Event facility contains event classes used to monitor locking activity in an instance of the Microsoft SQL Database Engine. These event classes can help you investigate locking problems caused by multiple users reading and modifying data concurrently.

Deadlock Graph

Created when an XML description of a deadlock is available.

Medium

Lock: Acquired

Created when acquisition of a lock on a resource has been achieved. (Disabled by default)

Medium

Lock: Cancel

Created when acquisition of a lock on a resource has been canceled. (Disabled by default)

Medium

Lock: Deadlock

Created when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim.

Medium

Lock: Deadlock Chain – Resource Type Exchange

Created when the Deadlock participant information is available for resource type Exchange.

Medium

Lock: Deadlock Chain – Resource Type Lock

Created when the Deadlock participant information is available for resource type Lock.

Medium

Lock: Escalation

Created when a finer-grained lock has been converted to a coarser-grained lock. (Disabled by default)

Medium

Lock: Released

Created when a lock on a resource has been released. (Disabled by default)

Medium

Lock: Timeout

Created when a request for a lock on a resource has timed out because another transaction is holding a blocking lock on the required resource. (Disabled by default)

Medium

Lock: Timeout (timeout > 0)

Created when a request for a lock on a resource has timed out (timeout >0) because another transaction is holding a blocking lock on the required resource. (Disabled by default)

Medium

SQL Objects Event

The SQL Objects Event facility contains general objects events.

Object:Altered – Begin

Created when an object is being altered (updated) by one of the ALTER statements. (Disabled by default)

Medium

Object:Altered - Commit

Created when committing changes to an object being updated by one of the ALTER statements. (Disabled by default)

Medium

Object:Altered – Rollback

Created when rolling back changes to an object updated by one of the ALTER statements.

Medium

Object:Created - Begin

Created when an object is being created using one of the CREATE statements. (Disabled by default)

Medium

Object:Created – Commit

Created when committing an object that has been created using one of the CREATE statements. (Disabled by default)

Medium

Object:Created – Rollback

Created when rolling back an object that has been created using one of the CREATE statements.

Medium

Object:Deleted – Begin

Created when an object is being deleted using one of the DROP statements. (Disabled by default)

Medium

Object:Deleted – Commit

Created when committing the deletion of an object. (Disabled by default)

Medium

Object:Deleted - Rollback

Created when rolling back an object that has been deleted.

Medium

SQL OLEDB Event

The SQL OLEDB Event facility contains general OLEDB events.

OLEDB Call - Completed

Created when the SQL Server has completed a call to an OLEDB provider for distributed queries and remote stored procedures.

Medium

OLEDB Call - Starting

Created when the SQL Server has issued a call to an OLEDB provider for distributed queries and remote stored procedures.

Medium

OLEDB DataRead - Completed

Created when the SQL Server has completed reading data from an OLEDB provider for distributed queries and remote stored procedures.

Medium

OLEDB DataRead - Starting

Created when the SQL Server is reading data from an OLEDB provider for distributed queries and remote stored procedures.

Medium

OLEDB Errors

Created when a call to an OLEDB provider returns an error.

Medium

OLEDB Provider Information

Created when a distributed query ran and collected information corresponding to the provider connection.

Medium

OLEDB QueryInterface - Completed

Created when the SQL Server has completed an OLEDB QueryInterface call for distributed queries and remote stored procedures.

Medium

OLEDB QueryInterface – Starting

Created when the SQL Server has issued an OLEDB QueryInterface call for distributed queries and remote stored procedures.

Medium

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating