The Microsoft.SqlServer.Server.TriggerAction enumeration is used by the Microsoft.SqlServer.Server.SqlTriggerContext class to indicate what action fired the trigger.
Syntax
Remarks
The Microsoft.SqlServer.Server.TriggerAction enumeration is used by the Microsoft.SqlServer.Server.SqlTriggerContext class to indicate what action fired the trigger.
For more information, see the Transact-SQL Reference of SQL Server Books Online.
Members
| Member Name | Description |
|---|---|
| AlterAppRole |
An ALTER APPLICATION ROLE Transact-SQL statement was executed. |
| AlterAssembly |
An ALTER ASSEMBLY Transact-SQL statement was executed. |
| AlterBinding |
An ALTER_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance. |
| AlterFunction |
An ALTER FUNCTION Transact-SQL statement was executed. |
| AlterIndex |
An ALTER INDEX Transact-SQL statement was executed. |
| AlterLogin |
An ALTER LOGIN Transact-SQL statement was executed. |
| AlterPartitionFunction |
An ALTER PARTITION FUNCTION Transact-SQL statement was executed. |
| AlterPartitionScheme |
An ALTER PARTITION SCHEME Transact-SQL statement was executed. |
| AlterProcedure |
An ALTER PROCEDURE Transact-SQL statement was executed. |
| AlterQueue |
An ALTER QUEUE Transact-SQL statement was executed. |
| AlterRole |
An ALTER ROLE Transact-SQL statement was executed. |
| AlterRoute |
An ALTER ROUTE Transact-SQL statement was executed. |
| AlterSchema |
An ALTER SCHEMA Transact-SQL statement was executed. |
| AlterService |
An ALTER SERVICE Transact-SQL statement was executed. |
| AlterTable |
An ALTER TABLE Transact-SQL statement was executed. |
| AlterTrigger |
An ALTER TRIGGER Transact-SQL statement was executed. |
| AlterUser |
An ALTER USER Transact-SQL statement was executed. |
| AlterView |
An ALTER VIEW Transact-SQL statement was executed. |
| CreateAppRole |
A CREATE APPLICATION ROLE Transact-SQL statement was executed. |
| CreateAssembly |
A CREATE ASSEMBLY Transact-SQL statement was executed. |
| CreateBinding |
A CREATE_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance. |
| CreateContract |
A CREATE CONTRACT Transact-SQL statement was executed. |
| CreateEventNotification |
A CREATE EVENT NOTIFICATION Transact-SQL statement was executed. |
| CreateFunction |
A CREATE FUNCTION Transact-SQL statement was executed. |
| CreateIndex |
A CREATE INDEX Transact-SQL statement was executed. |
| CreateLogin |
A CREATE LOGIN Transact-SQL statement was executed. |
| CreateMsgType |
A CREATE MESSAGE TYPE Transact-SQL statement was executed. |
| CreatePartitionFunction |
A CREATE PARTITION FUNCTION Transact-SQL statement was executed. |
| CreatePartitionScheme |
A CREATE PARTITION SCHEME Transact-SQL statement was executed. |
| CreateProcedure |
A CREATE PROCEDURE Transact-SQL statement was executed. |
| CreateQueue |
A CREATE QUEUE Transact-SQL statement was executed. |
| CreateRole |
A CREATE ROLE Transact-SQL statement was executed. |
| CreateRoute |
A CREATE ROUTE Transact-SQL statement was executed. |
| CreateSchema |
A CREATE SCHEMA Transact-SQL statement was executed. |
| CreateSecurityExpression |
Not available. |
| CreateService |
A CREATE SERVICE Transact-SQL statement was executed. |
| CreateSynonym |
A CREATE SYNONYM Transact-SQL statement was executed. |
| CreateTable |
A CREATE TABLE Transact-SQL statement was executed. |
| CreateTrigger |
A CREATE TRIGGER Transact-SQL statement was executed. |
| CreateType |
A CREATE TYPE Transact-SQL statement was executed. |
| CreateUser |
A CREATE USER Transact-SQL statement was executed. |
| CreateView |
A CREATE VIEW Transact-SQL statement was executed. |
| Delete |
A DELETE Transact-SQL statement was executed. |
| DenyObject |
A DENY Object Permissions Transact-SQL statement was executed. |
| DropAppRole |
A DROP APPLICATION ROLE Transact-SQL statement was executed. |
| DropAssembly |
A DROP ASSEMBLY Transact-SQL statement was executed. |
| DropBinding |
A DROP_REMOTE_SERVICE_BINDING event type was specified when an event notification was created on the database or server instance. |
| DropContract |
A DROP CONTRACT Transact-SQL statement was executed. |
| DropEventNotification |
A DROP EVENT NOTIFICATION Transact-SQL statement was executed. |
| DropFunction |
A DROP FUNCTION Transact-SQL statement was executed. |
| DropIndex |
A DROP INDEX Transact-SQL statement was executed. |
| DropLogin |
A DROP LOGIN Transact-SQL statement was executed. |
| DropMsgType |
A DROP MESSAGE TYPE Transact-SQL statement was executed. |
| DropPartitionFunction |
A DROP PARTITION FUNCTION Transact-SQL statement was executed. |
| DropPartitionScheme |
A DROP PARTITION SCHEME Transact-SQL statement was executed. |
| DropProcedure |
A DROP PROCEDURE Transact-SQL statement was executed. |
| DropQueue |
A DROP QUEUE Transact-SQL statement was executed. |
| DropRole |
A DROP ROLE Transact-SQL statement was executed. |
| DropRoute |
A DROP ROUTE Transact-SQL statement was executed. |
| DropSchema |
A DROP SCHEMA Transact-SQL statement was executed. |
| DropSecurityExpression |
Not available. |
| DropService |
A DROP SERVICE Transact-SQL statement was executed. |
| DropSynonym |
A DROP SYNONYM Transact-SQL statement was executed. |
| DropTable |
A DROP TABLE Transact-SQL statement was executed. |
| DropTrigger |
A DROP TRIGGER Transact-SQL statement was executed. |
| DropType |
A DROP TYPE Transact-SQL statement was executed. |
| DropUser |
A DROP USER Transact-SQL statement was executed. |
| DropView |
A DROP VIEW Transact-SQL statement was executed. |
| GrantObject |
A GRANT OBJECT Transact-SQL statement was executed. |
| GrantStatement |
A GRANT Transact-SQL statement was executed. |
| Insert |
An INSERT Transact-SQL statement was executed. |
| Invalid |
An invalid trigger action, one that is not exposed to the user, occurred. |
| RevokeObject |
A REVOKE OBJECT Transact-SQL statement was executed. |
| RevokeStatement |
A REVOKE Transact-SQL statement was executed. |
| Update |
An UPDATE Transact-SQL statement was executed. |
Requirements
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0