Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
On Delete Get Login
Message
De
26/03/2004 12:29:33
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
On Delete Get Login
Divers
Thread ID:
00890038
Message ID:
00890038
Vues:
72
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
Fil
Voir

Click here to load this message in the networking platform