Timeline for Passing info on who deleted record onto a Delete trigger
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 21, 2018 at 15:07 | comment | added | Airn5475 |
Good suggestion here, I really like this route. Kills two birds by capturing Who in the same step as triggering the real delete. Since this column is going to be NULL for every record in this table, it seems like it would be a good use of the SQL Server SPARSE column?
|
|
| Nov 13, 2014 at 22:32 | comment | added | Solomon Rutzky | David, actually you can pass info to triggers. Please see my answer for details :). | |
| Nov 13, 2014 at 20:35 | history | edited | David Spillett | CC BY-SA 3.0 |
Clarified on user types
|
| Nov 13, 2014 at 20:34 | comment | added | webworm | I see your point. I would indeed be looking to log the application level user. | |
| Nov 13, 2014 at 20:29 | history | edited | David Spillett | CC BY-SA 3.0 |
Clarified on user types
|
| Nov 13, 2014 at 20:24 | history | answered | David Spillett | CC BY-SA 3.0 |