My approach to audits is answering all relevant questions: who, what, when, where, and sometimes I add a how and why as well for a comment type of field.  I...

The rules of Normalization say that you should have non meaningful keys.  An identity int is great for this purpose.  This can be replaced by a RowGUID (uniqueidentifier).  I also...