Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Tracy J Powell: "Thank you VERY much for the quick and helpful response. I will definitely upgrade as soon as possible. Your products are great and I use them daily".
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".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Editing CLR DDL trigger properties

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

Name

Displays CLR DDL trigger name.
 
 

Note: the name of the object must be unique among all the object names in the server. You can use any identifier that is allowed by Microsoft SQL server.

 

Comment

Specify a comment to the CLR DDL trigger.

 

Create Date

Indicates the date when the CLR DDL trigger was created.

 

Modify Date

Indicates the date when the CLR DDL trigger was last modified.

 

Execute As

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

 

Events

This field allows you to specify events the execution of which causes a CLR 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.

 

 Enabled

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

 

Assembly, Class, Method

Specifies the method of a .NET Framework assembly for a CLR stored function to reference. Class must be a valid SQL Server identifier and must exist as a class in the Assembly. The assembly must already have been created in the database.

 

See also: Assemblies
 

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