September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Managed triggers are static methods of a .NET class decorated with the SqlTrigger attribute. SqlTrigger has three named parameters:
• Event—A required string-valued parameter that tells SQL Server which type of trigger you’re defining, as is done when defining T-SQL triggers.
• Target—A required string-valued parameter that tells SQL Server which schema and table you’re attaching the trigger to.
• Name—An optional string parameter that tells the deployment routine what to call the trigger when it is created in the database.
The implementation contract for a managed trigger is only that it be a static method that returns void.
Inside the method body of a managed trigger, you need to get a reference to the execution ...