You didn't say what version you were using. Please note that 'INSTEAD OF'
triggers are only available in SQL Server 2000.
Also, to add to what Amy said, they don't actually fire before the fact; as
the name implies, they fire INSTEAD OF doing the action. So if you have an
INSTEAD OF UPDATE trigger, the trigger will fire, and the update will not
happen, unless the trigger code includes the same update code. There are
examples of both types in the Books Online.
SQL Server MVP
"Amy" <com> wrote in message