TechNet
Export (0) Print
Expand All

ServerDdlTrigger Class

 

The ServerDdlTrigger object represents a SQL Server data definition language (DDL) trigger.

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


[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[SfcElementTypeAttribute("DdlTrigger")]
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
public sealed class ServerDdlTrigger : DdlTriggerBase, ISfcSupportsDesignMode

NameDescription
System_CAPS_pubmethodServerDdlTrigger()

Initializes a new instance of the ServerDdlTrigger class.

System_CAPS_pubmethodServerDdlTrigger(Server, String)

Initializes a new instance of the ServerDdlTrigger class on the specified instance of SQL Server and that has the specified name.

System_CAPS_pubmethodServerDdlTrigger(Server, String, ServerDdlTriggerEventSet, String)

Initializes a new instance of the ServerDdlTrigger class on the specified database that has the specified name. The trigger responds to the specified event set and runs the specified batch.

System_CAPS_pubmethodServerDdlTrigger(Server, String, ServerDdlTriggerEventSet, String, String, String)

Initializes a new instance of the ServerDdlTrigger class on the specified instance of SQL Server and that has the specified name. The trigger responds to the specified event set and runs the specified batch.

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.)

NameDescription
System_CAPS_pubmethodAlter()

Updates any DatabaseDdlTrigger object property changes on the instance of SQL Server.(Inherited from DdlTriggerBase.)

System_CAPS_pubmethodCreate()

Creates a database data definition language (DDL) trigger on the instance of SQL Server as defined by the DatabaseDdlTrigger object.(Inherited from DdlTriggerBase.)

System_CAPS_pubmethodDiscover()

Discovers a list of type Object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodDrop()

Drops the database data definition language (DDL) trigger.(Inherited from DdlTriggerBase.)

System_CAPS_pubmethodDropIfExists()

(Inherited from DdlTriggerBase.)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFormatSqlVariant(Object)

Formats an object as T: Microsoft.Data.Schema.Sql.DataGenerator.SqlVariant type.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetContextDB()

Gets the context database that is associated with this object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetDBName()

Gets the database name that is associated with the object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_protmethodGetPropValue(String)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetPropValueOptional(String)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetPropValueOptionalAllowNull(String)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetServerObject()

Gets the server of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodInitialize()

Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodInitialize(Boolean)

Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.)

System_CAPS_protmethodIsObjectInitialized()

Verifies whether the object has been initialized.(Inherited from SqlSmoObject.)

System_CAPS_protmethodIsObjectInSpace()

Verifies whether the object is isolated or connected to the instance of SQL Server.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodIsSupportedProperty(String)

(Inherited from SqlSmoObject.)

System_CAPS_pubmethodRefresh()

Refreshes the script name.(Inherited from ScriptNameObjectBase.)

System_CAPS_pubmethodScript()

Generates a Transact-SQL script that can be used to re-create the database data definition language (DDL) trigger.(Inherited from DdlTriggerBase.)

System_CAPS_pubmethodScript(ScriptingOptions)

Generates a Transact-SQL script that can be used to re-create the database data definition language (DDL) trigger as specified by the script options.(Inherited from DdlTriggerBase.)

System_CAPS_pubmethodScriptHeader(Boolean)

Generates a Transact-SQL script that can be used to re-create the database data definition language (DDL) trigger header as specified by the script options.(Inherited from DdlTriggerBase.)

System_CAPS_protmethodSetParentImpl(SqlSmoObject)

Sets the parent of the SqlSmoObject to the newParent parameter.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodToString()

Returns a String that represents the referenced object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodValidate(String, Object[])

Validates the state of an object.(Inherited from SmoObjectBase.)

NameDescription
System_CAPS_pubeventPropertyChanged

Represents the event that occurs when a property is changed.(Inherited from SqlSmoObject.)

System_CAPS_pubeventPropertyMetadataChanged

Represents the event that occurs when property metadata changes.(Inherited from SqlSmoObject.)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.Discover()

Discovers any dependencies.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetDomainRoot()

Returns the root of the domain.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetParent()

Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetPropertyType(String)

Gets the type of the specified property.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetPropertyValue(String, Type)

Gets the value of the specified property.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetUrn()

Gets the Unified Resource Name (URN) of the object.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.Resolve(String)

Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.SetObjectState(SfcObjectState)

Sets the object state to the specified SfcObjectState value.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.SetPropertyValue(String, Type, Object)

Sets the property value.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcPropertyProvider.GetPropertySet()

Gets the interface reference to the set of properties of this object.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privpropertyISfcSupportsDesignMode.IsDesignMode

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events.

SQL Server Management Objects (SMO) provides programmatic access to allow management of all DDL trigger functionality with the DatabaseDdlTrigger object and the ServerDdlTrigger object.

Database DDL triggers respond to events within the scope of the database and server DDL triggers respond to events within the scope of the SQL Server instance.

To get ServerDdlTrigger object properties, users can be a member of the public fixed server role.

To set ServerDdlTrigger object properties, users must have CONTROL SERVER permission on the server or be a member of the sysadmin fixed server role.

To create or drop a server-level DDL trigger, users must have CONTROL SERVER permission on the server or be a member of the sysadmin fixed server role.

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft