Microsoft® SQL Server 2012 Unleashed

Developing Managed Triggers

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