Re: Audit 3 fields in one table

Hello,

Take a look into the INSERT/DELETE Triggers in books online. So when ever
there is a delete or Insert happendson table HandoverClinicalChanges a
record
will be inserted to the audiit table. See the below URL for examples and
usages of triggers.

http://www.sql-server-performance.com/nn_triggers.asp

Thanks
Hari

"Kev" <kevin.vaughan@xxxxxxxxxxxxxxx> wrote in message
news:1172208080.462256.162750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
I am unfamiliar with SQL Server 2005 but want to learn more.
I have an application with a MS Access 2003 Front end and a 2005 SQL
Server backend.
I have a table called HandoverClinicalChanges, there are 3 main fields
which are updated by Doctors - usually by adding to the end of the
previous entry, sometimes by deleting the previous entry and adding
their own.

I want to be able to capture the changes and additionsthey record to
these fields in a table (? audit table).
Is there an easy way do this in SQL SERVER 2005 or should I do it in
ACCESS FE?
Thank you for any help and advice.
Regards
Kev



.