Browse by Tags

Triggers within CLR - advantage over TSQL

Published 4 September 7 4:10 AM | SSQA.net

You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested...

Filed under: sql server, performance, query, clr, trigger, table, tsql, recursive, cte

TSQL to find all triggers in a database including their count

Published 23 August 7 3:28 AM | SSQA.net

For SQL Server 2000 version: SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig = s1.id THEN 'Delete' WHEN S2.instrig = s1.id THEN 'Insert' WHEN S2.updtrig = s1.id THEN 'Update' END 'TriggerType' ,...

Filed under: sql server, version, trigger, tsql, tables

How do I view the definition of a server-level trigger?

Published 16 July 7 7:43 AM | SSQA.net

SELECT definition FROM sys.server_sql_modules; GO Books online documented the usage of triggers for the business needs: Creates a DML, DDL, or logon trigger. A trigger is a special kind of stored procedure that automatically executes when an event occurs...

Filed under: sql server, server, trigger, tsql