Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Change Auditor for SQL Server 7.1.1 - Event Reference Guide

Table of Contents

Introduction Change Auditor for SQL Server Events

SQL Broker Event SQL CLR Event SQL Cursors Event SQL Database Event SQL Deprecation Event SQL Errors and Warnings Event SQL Full Text Event SQL Locks Event SQL Objects Event SQL OLEDB Event SQL Performance Event SQL Progress Report Event SQL Query Notifications Event SQL Scan Event SQL Security Audit Event SQL Server Event SQL Session Event SQL Stored Procedures Event SQL Transactions Event SQL TSQL Event SQL User-Configurable Event SQL Data Level Event

SQL Full Text Event

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

Table 7. SQL Full Text events
Event	Description	Severity
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.

Table 8. SQL Locks events
Event	Description	Severity
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.

Table 9. SQL Objects events
Event	Description	Severity
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.

Table 10. SQL OLEDB events
Event	Description	Severity
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

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center