Kaelum Yodi

Hey Paul,

The viewer is definitely coming along, but it looks like the content is still lacking.  BTW, have you thought about online use of the Help Viewer?  Where the help viewer would access on online help service instead of the local help service?  It's not something I would use very often, but it might be nice for those who don't mind the delay of using online help.  Plus, it would allow for a single experience for all viewers and allow the exact same favorites to be used both online and offline.

Take it easy...

Virtually every project that I've worked on has required full audit tracking as most of them are ecommerce or financial projects.  Using an IsDeleted flag is the easiest and overall best way to go.  Adding the field to an existing site and fully implementing it should take no more than a couple days.  If it takes longer than that, you are doing something wrong.  For tables that allow changes, we add the following fields at the end of the table:

[LastChangeBy] uniqueidentifier
[LastChangeDate] datetime
[IsDeleted] bit

For tables that do not allow changes (i.e. Payments), we add the following fields at the end of the table:

[CreatedBy] uniqueidentifier
[CreatedDate] datetime

This way we always know exactly who made what change, and when.