adding reasons to temporal tables

• DamianC

  SSCrazy Eights

  Points: 8023

  More actions

  January 15, 2020 at 1:20 pm

  #3715594

  Hello

   

  I've created a temporal table and can record changes.

  With temporal tables, it writes the row as-is then performs any modification.

  I'd like to record who made a change and why.

  This works fine for updates but is it possible with deletions?

  I can record who by using a computed column (AS SUSER_SNAME())

  With deletions, I can't record the why though

  Is this possible?

   

  Thanks

  - Damian

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  January 16, 2020 at 2:10 pm

  #3715983

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.