SQL Server 2000 greatly enhances trigger functionality,
extending the capabilities of the triggers you already know and love, and adding
a whole new type of trigger, the "Instead Of" trigger.
If you are already familiar with programming triggers then
read on, but if you are new to the subject then it would be worth reading about
triggers in Books Online, or taking a look at the Triggers section on my own SQL Server page,...