Browse by Tags

All Tags » tsql » table » query
  • Triggers within CLR - advantage over TSQL

    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 triggers server configuration option. So how it can be escaped using CLR and how procedural and ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on September 4, 2007