As a general rule any table I design that has data entry, I'll add four 'auditing' columns to it that populate via INSERT and UPDATE triggers:
created_dt - datetime - of the entry
created_by_id - varchar(30) - SUSER_NAME() of the person creating it
last_updated_dt - datetime - of any insert-update
last_updated_by_id - varchar(30) - SUSER_NAME() of the person updating it.
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.