Audit one field in SQL Server 2005

Is it possible to use an update trigger to audit one field in a table? thanksHi Pete
An update trigger will fire no matter what columns are updated, but within
the trigger you can use a special construct IF UPDATE (column_name).
So you could check if one particular column was updated, and do what you
need to do, and otherwise, do nothing and return from the trigger.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"pete" <pete@.discussions.microsoft.com> wrote in message
news:5F5E90A7-415F-491A-9A95-BC8E19CAD72C@.microsoft.com...
> Is it possible to use an update trigger to audit one field in a table?
> thanks