We know about triggers as they exist in SQL Server 2000 and its previous versions ? triggers that fire in response to INSERT, UPDATE and DELETE events.

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