All,

I am attempting to push records to another DB using an insert trigger.CREATE


TRIGGER Source_ins_tr ON [Source]
FOR INSERT

AS

INSERT INTO DestinationDB.DestTable(location,[name],calltaker)
SELECT object, ticket_number, username
FROM inserted

This doesn't work. How should I go about doing this?

poffield@liberty.edu

Thanks in advance
Phil