General information
Forum:
Microsoft SQL Server
Title:
On Delete Get Login
Hello,
I have a trigger that fires ON DELETE. This trigger takes the deleted row and performs an insert of this row into the DeletedRowsTable.
I would also like to insert the username or login of the deleted row.
Does anyone here know how to do this?
So, when the trigger fires.. i would like to be able to insert the deleted row as well as the user that deletes this row
into the DeletedRowsTable.
Thanks for your ideas,
Alvin
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only