Microsoft.SqlServer.Server.SqlTriggerContext Class

Provides contextual information about the trigger that was fired.

See Also: SqlTriggerContext Members


public sealed class SqlTriggerContext


The contextual information provided includes the type of action that caused the trigger to fire, which columns were modified in an UPDATE operation, and, in the case of a data definition language (DDL) trigger, an XML EventData structure (see "Transact-SQL Reference" in SQL Server Books Online) that describes the triggering operation.

An instance of Microsoft.SqlServer.Server.SqlTriggerContext is available from the Microsoft.SqlServer.Server.SqlContext class, when the code is running inside a trigger through the SqlContext.TriggerContext property.


Namespace: Microsoft.SqlServer.Server
Assembly: System.Data (in System.Data.dll)
Assembly Versions:
Since: .NET 2.0