Hi, Everyone.
I want to keep the log detail for my record
in MS SQL Database when user Delete a record.
So I have a SQL Trigger Delete Function in related Table.
What I want to keep is the User Name From My Software's User
who delete the record, But i have no any field keep in the table,
Is that MS SQL have any session variable or temp variable that
can let my system to update and run at once together with Trigger Delete and
so keep in the log detail table ?
My Program Current Login Username, I have keep it Database,
But The problem is :-
1> There are multi-user login at a time.
2> During Trigger Delete, username that delete not send to trigger.
So, What i want to know is, how or any other way to Send / communicate
with Trigger Delete when ...
Go to the complete details ...