Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Jim Salmons: "That is excellent news! I will look forward to a future update with these features. It will be attention to such details that further distinguishes your excellent products from the competition.

As always, I appreciate your great products and your demonstrated customer service is equal to the high quality of your products".
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".


Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Editing DDL trigger properties

Specify DDL Trigger options according to your needs. The detailed description is given below.


The field contains the definition of the DDL trigger. It describes the trigger conditions and actions. The trigger actions specified in the Transact-SQL statements go into effect when the DDL operation is tried. Triggers can include any number and kind of Transact-SQL statements, with exceptions.



Displays the DDL trigger name.



Specify a comment to the DDL trigger.


Create Date

Indicates the date when the DDL trigger was created.


Modify Date

Indicates the date when the DDL trigger was last modified.



Encrypts the text of the CREATE TRIGGER statement. Using Encrypted prevents the trigger from being published as part of SQL Server replication.


Execute As

Specifies the security context under which the DDL Trigger is to be executed (For details see Execute As Clause (Microsoft SQL 2005 References)).



This field allows you to specify the events execution of which causes a DDL trigger to fire. Click ellipse button (...) on the right of the events text area to select this events or event groups using the Add Event Dialog.



Disabling a trigger does not drop it. The DDL trigger still exists as an object in the current database/server. However, the DDL trigger does not fire when any Transact-SQL statements on which it was programmed are executed.


To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.


It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.

Prev Return to chapter overview Next