Hi Richard,

I Agree that  INSERTED and DELETED tables have blob fields within INSTEAD OF triggers.  Thank you for correcting the mistake. However, I disagree with what you say with UPDATETEXT/WRITETEXT.  If you are using stored procedures to update the tables, you can always refer the additional column (with less cost)  and update last_modified field.  Why do you want triggers on the first place.  Triggers is one of the mechanism where we can control ad-hoc queries. What about adhoc queries using UPDATETEXT/WRITETEXT? It shows that, triggers is not the best solutions.

On the other hand, triggers could be used against tables which do not have blob fields. I use it.  it is one of the best methods to add audit component against, existing table.