that make sense. Thanks for the quick reply

My company just went through PCI audit and we use Idera Sql Compliance, Lumigent was too expensive for us.  The SQL Compliance Manager satisfied the auditors requirements which log all...

thanks for all your answer. I know trigger can log insert, update, delete but we are required to also log select as well. I search and found there...

Thanks for your quick reply Brian,

Adding that datetime colum works for me.  Why didn't I think of that, ughh.  Thanks again.