Question on implementing audit trial using triggers

Question

Question on implementing audit trial using triggers

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Graeme100 SSCrazy Eights Points: 8054 More actions · Answer 1

Hi,

This can be as complicated as you want it to be.

One idea is to have INSERT, UPDATE, DELETE triggers on your tables that capture Tablename, Column, PK Value, Old VAlue, New Value.

You could capture the entire row if you wish.

Depends on what you want to do with the Audit Log.

HTH

Graeme

Graeme100 SSCrazy Eights Points: 8054 More actions · Answer 2

Sorry...missed a bit.

You can create a script that generates the triggers automatically and writes the entire row before change into a column and the entire row after change into another column. You are , of course, limited by the amount of data you can get into one column.

Regards...Graeme

RyanRandall SSChampion Points: 13623 More actions · Answer 3

http://mindsdoor.net/SQLTriggers/AuditTrailTrigger.html

http://mindsdoor.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

RandomStream Hall of Fame Points: 3735 More actions · Answer 4

Thanks to everyone, especially to Ryan. The solution in the first article works very well for our needs.

RyanRandall SSChampion Points: 13623 More actions · Answer 5

I guess it's Nigel you should be thanking!

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.