Best way to log database table transactions?

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.
India

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 [Administrator] lakhansin-22735, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts