views:

971

answers:

1

I have been researching audit triggers for some of my sql tables. I came across this article on simple-talk.

Now I know that the COLUMNS_UPDATED() function used here is only supposed to be available on SQL Server 2005 and later but it appears to work under 2000 as well. Is this perhaps a classic Microsoft undocumented feature in 2000? Or am I heading for trouble using this method with 2k?

If it is the case that COLUMNS_UPDATED() is unsupported in 2k, can anyone suggest an alternative method of auditing just the changes from a table.

+1  A: 

COLUMNS_UPDATED() is fully supported in sql server 2000.

Edit: the link to the docs.

Mladen Prajdic
Could you perhaps link to any documentation, as Books Online for 2k doesn't have anything relating to COLUMNS_UPDATED().
Neil Albrock
Thanks for that Mladen. I realise now that I've probably looked right at the section of the CREATE TRIGGER documentation where COLUMNS_UPDATED() is mentioned, thank you for bringing it back to my attention.
Neil Albrock