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.