I dont have any idea about SSIS package. I tried to make new Flat file in SSIS but not worked. Can u please give me practical example.???

Thanx for the reply. I did the same on the same server but its not working. Actually i wanted to do the same on two different Sql server. My one...

Thanx for the reply. I did the same on the same server but its not working. Actually i wanted to do the same on two different Sql server. My one...

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...