Export (0) Print
Expand All

DDL_TRIGGER_EVENTS

SQL Server 2005

This event type or event group can be specified when you create Event Notifications to monitor and respond to activity in the database or server instance. Event notifications can be created directly in the SQL Server Database Engine or by using the WMI Provider for Server Events. Some events can also be used when you create DDL triggers. For more information, see Designing DDL Triggers.

Parent: DDL_DATABASE_LEVEL_EVENTS

Children: DROP_TRIGGER, CREATE_TRIGGER, ALTER_TRIGGER

Inherited from Parents

Name CIM Type

UserName

String

SPID

Sint32

LoginName

String

PostTime

DateTime

SQLInstance

String

DatabaseName

String

ComputerName

String

Event Properties

Name CIM Type

SchemaName

String

TSQLCommand

String

ObjectName

String

ObjectType

String

TargetObjectType

String

TargetObjectName

String

Community Additions

ADD
Show:
© 2014 Microsoft