Dan G,

Thanks for the info. I couldn't find them either because I was looking for a separate function, I didn't realize it was just a clause of the create trigger command - the article at sql-server-performance.com was misleading.

>Dan,
>
>Yeah, these functions are well hidden ;-)
>
>Check CREATE TRIGGER.
>
>>>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.