[RESOLVED] create trigger

[deshpandesn]

Hi Everybody i want to create trigger in sql server 2008 database
i want to insert data into another table in same database after parent database inserted record

i am trying something like this

CREATE TRIGGER INS_LOGDATA
ON NGAC_AUTHLOG
AFTER
INSERT
(select Userid,Transactiontime from NGAC_AUTHLOG )
AS Insert into LOGDATA values (Userid,ActDate,ActTime) values (Userid,ActDate,ActTime)

[si_the_geek]

Thread moved to the 'Database Development' forum

[TysonLPrice]

It would be something like this:

INSERT LOGDATA(Userid,ActDate,ActTime)
select Userid,Transactiontime,ActTime from inserted

You'll need to resolve the column names from inserted (which are what is in NGAC_AUTHLOG) to the names in LOGDATA