I can't find the functions either. They seem like pretty darn important functions! I find it amazing that they are omitted from the documentation. I'll continue to look into them. I haven't tried them yet.

The article is at:

http://www.sql-server-performance.com/trigger_tuning.asp

But unfortunately, it doesn't provide the parameters for the functions, or enough detail to actually implement.



>>To help reduce the unnecessary running of code in an UPDATE trigger, you can take advantage one of two different functions: UPDATE() (available in SQL Server 2000) or COLUMNS_UPDATED() (available in SQL Server 7.0 and 2000).
>
>Well, ya learn something new every day. And the odd part is that I can't find either function in BOL.