September 26, 2017 at 6:08 am
Hello All,
I am creating database schema for an application from scratch. I have an idea to use four standard columns CreationDT, CreatedBy, ModifiedDT, ModifiedBy in each table I am creating just for audit purpose. But, one the another edge I am thinking that is it really good idea to do for every table. Can anybody please share your ideas?
Regards
VG
September 26, 2017 at 6:27 am
Depends.
What do you need them for, and what are your audit needs?
If you don't care about changes to rows, don't use them.
If you need to know what changed, then they're not adequate.
If you just need to know when a row changed, then use a modified date.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 27, 2017 at 7:30 am
Thanks
Regards
VG
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply