How to get username in Delete trigger

how to get username ,userid in delete trigger ..........

i have created delete tigger all tables.

when user deleting data through application.

deleteind details saved in another table ,but i not able get username or userid ...

Re: How to get username in Delete trigger

select username,userid from DELETED

In triggers INSERTED and DELETED are availble to select data from

Re: How to get username in Delete trigger

since data is deleted through application...

iam able to get only Deleted details and also updated details from table.

Not username who logged through application and Delete the data..

So i any other way get application logged username in Sql trigger......

Thanks in Advance ..

Rajeshkumar

Re: How to get username in Delete trigger

rajeshkumar1988

since data is deleted through application...

iam able to get only Deleted details and also updated details from table.

Not username who logged through application and Delete the data..

So i any other way get application logged username in Sql trigger......

Thanks in Advance ..

Rajeshkumar

Hi,

If you couldn't find username and userid from table, you could use another way to store them in the table. Did you get the username and userid when he login in the application? You could store them in the parameters, and after deleting data, use insert clause to insert these two values into your table instead of Sql trigger.

Thanks.