dwain.c (1/23/2013)

---

Gazareth (1/23/2013)

---

dwain.c (1/22/2013)

---

Upon reflection, I realized that capturing the UserID that deleted the record is not possible in the TRIGGER itself.

So I went back and modified the code to show you how it could be done. I don't particularly like it but it works and maybe someone has a better idea.

SUSER_SNAME() / ORIGINAL_LOGIN() ?

As those would be associated with SQL Server, they may bear no relation to the application login, which is most likely what you'd want to capture.