Hi all,

following is my trigger:

CREATE TRIGGER trigger1 ON Table1 after Update AS

begin

INSERT INTO table2

SELECT * from inserted

end

in above Query i want to add record from inserted table to table2 which is on another Database2.

and Table1 is in Database1.

After Updating Database1.Table1 trigger should get fire and record get inserted into Database2.Table2.

How can we do this????