|
CLR Triggers A CLR trigger could be a Date Definition or Date Manipulation Language trigger or could be an AFTER or INSTEAD OF trigger.
Methods written in managed codes that are members of an assembly need to be executed provided the assembly is deployed in SQL 2005 using the CREATE assembly statement.
The Microsoft.SqlServer.Server Namespace contains the required classes and enumerations for this objective.
One can create a database object inside SQL Server that is developed in an assembly created in .Net CLR - it’s a special type of stored procedure that executes on an event. CLR triggers can reference data in the inserted and deleted tables, know about modified columns after an update statement, and access information about objects affected in the database as a result of DDL statements.
|
