The three articles in the Fall 2009 edition of SQL>UPDATE_RMOUG are “Beware…” (Another Look at Triggers), “Database Administrator’s Code of Ethics”, and “Using the PL/SQL Profiler.” ...

AutoCommit is on, but that's something else, and won't help here.<BR><BR>I don't know enough about SQL Server's guts to know if it runs each trigger in a transaction by itself.

I'm having trouble figuring out how to write a particular trigger to avoid having it recurse. This trigger is an after update trigger that operates on the same table that fires it. This is a ...

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.