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.