Alvin,
The SYSTEM_USER function returns user login name. See BOL for details.
>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,
The SYSTEM_USER function returns user login name. See BOL for details.
--sb--