
March 1st, 2004, 02:20 AM
|
|
Contributing User
|
|
Join Date: Feb 2004
Posts: 31
Time spent in forums: < 1 sec
Reputation Power: 5
|
|
|
SQL Trigger Function
Currently I am using this particular Trigger to catch the delete record and log it. But there is one problem I face is that I can't catch the persons computer name, IP and also user login name. Does anyone know how to do it? or is it that triggers cannot do so. Then can you suggest to me a better idea or option. Please do tell me thanks in advance.
CREATE Trigger TrigDelete on [Staff Details]
for Delete
as
Declare
@temp int
Select @temp = S_Code from deleted
insert into [Log] values ('Trigger','Delete', @temp,getdate())
|