TRIGGER HELP

[kissarmi]

Hi,

I would like to use a trigger with some of my tables to build some kind of audit file. I would like to keep up with certain information any time one of these tables is updated. That would be information such as user and password info, machine name from where the table is being accessed, and maybe some other system info. Can the trigger access this? How?

Thanks for any help.

 

[rarubio1]

Try the following:

CREATE TRIGGER trgAudit ON [dbo].[SourceTableName]
FOR INSERT AS

BEGIN
INSERT DestinationTableName(User,password,machine)
SELECT User, password, machine
FROM Inserted
END