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

FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan"

Published 20 August 7 5:18 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you run a query that...

Filed under: sql server, query, sp2, kba, trigger, processor