Hi Paul,

Thanks for the reply.

yes, that makes sense. Can you please help me with that code in the Script task?

Thanks very much in advance.

Regards,

Swathi.

Thanks Michael,I'll try that

Michael,

Thanks for the immediate response...can you give me information about how to implement transactional replication for this case??

Actually I wrote this type of triggers on 19 tables, all are working...

Ten Centuries---

I have seen the link that you have provided....but got a question ... The main server is on sql server 2005 SP2,but the remote (linked) server is on sql...

Micheal,

Thanks for the reply...I already tried in that way also...with NO LUCK 🙁

Do you have anything else in your mind which is causing this problem???

Anyone, Please help me in this...