Information générale
Forum:
Microsoft SQL Server
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement