Best way to log database table transactions?

Posted by lakhansin-22735 under Sql Server on 7/8/2013 | Points: 10 | Views : 587 | Status : [Member] | Replies : 1
Hello Everyone!

Can anyone suggest me, the best way to log table's transactions?

Right now, I just fired a trigger for following operations INSERT, UPDATE, DELETE on a table like 'Table1' and this trigger insert a new row in another table like 'Table1_Trail' on each and every operation.
Is this a good option to log table's transactions?

Thanks in advance.

Lakhan Singh
Tech Lead
BeyondKey System Pvt. Ltd.
Indore, M.P.


Posted by: Vuyiswamb on: 7/8/2013 [Member] [MVP] [Administrator] NotApplicable | Points: 25

a Trigger a best way, but there is a performance hit but not major , it depends how busy is that table.But as long as it works , leave it there. its the best place.

Thank you for posting at Dotnetfunda

lakhansin-22735, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response