May 13, 2011 at 8:53 am
If a business user came to you today and asked who made changes to a record, what mechanisms do you have in place to know:
1) who changed the record
2) what exactly they changed
3) when they changed it
???
The system I've used in the past is that the current record have two columns that show the user ID and date last updated. There is a history table that retains every insert, update, and delete record against the non-history table and shows everything from the original insert all the way up to the current record. The history table then can be used to show the who, what, and when.
Have you seen alternate ways of managing this information for auditing purposes? If so, what?
May 13, 2011 at 9:11 am
Use Audits and Database Audit Specification
http://msdn.microsoft.com/en-us/library/cc280472.aspx
http://technet.microsoft.com/en-us/library/cc280404.aspx
And you can use EVENT_DATA also
http://technet.microsoft.com/en-us/library/ms173781.aspx
http://msdn.microsoft.com/en-us/library/ms187909.aspx
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 13, 2011 at 9:17 am
Many thanks Syed!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply