>Thanks for the reply Kevin,
>i've examinated your sample . would you like to write here sample insert_update_delete_trigger code for northwind database customers table for all columns and structure of log table ?
>
>TIA

Here are some sample audit trail triggers:

http://www.nigelrivett.net/AuditTrailTrigger.html

Here is a script that will generate audit triggers for you:

http://www.nigelrivett.net/GenerateTriggerForAudit.html

Here is a script of a generic auditor SP that can be used on all tables:

http://www.nigelrivett.net/AuditTrailTrigger.html

He also has alot of other good SQL stuff on his web site.

BOb