[/quote]

Sure no problem. I will mask the data in records but i believe it should give you solid example of system in place.

This the example of one row in audit log table: (result of query bellow)

mcerkez2010-07-27 17:50:54.643303759modifyVoucherDenomination4<?xml version="1.0" encoding="utf-16" standalone="yes"?><log object="VoucherDenomination" action="modify"><field name="id" value="6" /><field name="barcode" value="00000000000000" /><field name="recharge_period" value="000" /><field name="voucher_name" value="XXX" /><field name="voucher_value" value="00000" /><field name="product_code" value="1234" /><field name="serviceproviderservice" value="XXX" /><field name="serviceprovider" value="XXX" /><field name="default_min_active_quantity" value="10000" /><field name="default_min_activation_quantity" value="000" /><field name="default_min_inactive_quantity" value="0000" /><field name="mtime" value="27.7.2010 17:50:54" /><field name="ctime" value="20.2.2008 17:20:51" /><field name="deleted" value="False" /></log>

And this is the quary that selects all columns from audit log table.

SELECT top 1 username

,[ctime]

,[id]

,[action_type]

,[record_type]

,[errorLevel]

,[description]

,[extraInfo]

FROM [dbo].[AuditLog]

This configuration allows us to create view onto audit log table depending on our needs. Also ordering by ctime (cration time) column allows us to maintain chain of modification on particular database object.

If you have any other question please don't hesitate to ask.[/quote]

curious how the record gets into the table. Is it a trigger?