Wednesday, March 7, 2012

Audit one field in SQL Server 2005

Is it possible to use an update trigger to audit one field in a table? thanks
Hi 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

No comments:

Post a Comment