Using a Trigger to determine when a column was changed

Hi,

I'm new to Triggers, so forgive the elementary question. We have a
process that saves data from a VB2005 form into a table in MS SQL
2005, and it saves all data whether the user changed the value or
not. Is it possible to create a trigger for this table where a log
can be written to if a value is updated with different data? Since
technically all data in the table is being updated I wasn't sure if a
trigger could distinguish between data that didn't change and data
that did.

Thanks --

Alex

re: Using a Trigger to determine when a column was changed

>Is it possible to create a trigger for this table where a log can be written to if a value is updated with different data? <<

Read this before you make this design error and get in trouble with
the auditors:

http://www.tdan.com/view-special-features/8135