Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
On Delete Get Login
Message
From
26/03/2004 12:29:33
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
On Delete Get Login
Miscellaneous
Thread ID:
00890038
Message ID:
00890038
Views:
73
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
Map
View

Click here to load this message in the networking platform