ServerDdlTrigger Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets or sets the Boolean property value that specifies whether ISO NULL handling is enabled in the data definition language (DDL) trigger.

System_CAPS_pubpropertyAssemblyName

Gets or sets the name of the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.

System_CAPS_pubpropertyBodyStartIndex

Gets the index value that represents the start of the data definition language (DDL) trigger text body.

System_CAPS_pubpropertyClassName

Gets or sets the name of the class in the assembly that contains the managed code that is executed when the data definition language (DDL) trigger is raised.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the server data definition language (DDL) trigger was created.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the server data definition language (DDL) trigger was last modified.

System_CAPS_pubpropertyDdlTriggerEvents

Gets or sets the set of data definition language (DDL) events that raise the server DDL trigger.

System_CAPS_pubpropertyExecutionContext

Gets or sets the execution context type used by server DDL trigger, itself, the caller, or a specified login.

System_CAPS_pubpropertyExecutionContextLogin

Gets or sets the login under the context of which the server DDL trigger executes.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the server data definition language (DDL) trigger.

System_CAPS_pubpropertyImplementationType

Gets or sets the implementation type for the server data definition language (DDL) trigger.

System_CAPS_pubpropertyIsEnabled

Gets or sets the Boolean property value that specifies whether the server data definition language (DDL) trigger is enabled.

System_CAPS_pubpropertyIsEncrypted

Gets or sets a Boolean property value that specifies whether the Transact-SQL batch or managed code is encrypted.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the server data definition language (DDL) trigger is a system object.

System_CAPS_pubpropertyMethodName

Gets or sets the name of the method that is owned by the class in the assembly, which is executed when the trigger is raised.

System_CAPS_pubpropertyName

Gets or sets the name of the object.(Inherited from NamedSmoObject.)

System_CAPS_pubpropertyParent

Gets or sets the Server object that is the parent of the ServerDdlTrigger object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQuotedIdentifierStatus

Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyText

Gets or sets the Transact-SQL statement that defines the server data definition language (DDL) trigger.

System_CAPS_pubpropertyTextBody

Gets or sets the body text that is used in the definition of the database data definition language (DDL) trigger.(Inherited from DdlTriggerBase.)

System_CAPS_pubpropertyTextHeader

Gets or sets the header text that is used in the definition of the database data definition language (DDL) trigger.(Inherited from DdlTriggerBase.)

System_CAPS_pubpropertyTextMode

Gets or sets the Boolean property value that specifies whether the DatabaseDdlTrigger header is editable as text. (Inherited from DdlTriggerBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show: