October 18, 2010 at 2:45 am
Hi All,
I have a problem in Replication (Snapshot replication)
I have two servers . 'A' server( sql 2000 Ver) another is 'B' server (sql 2005 Ver)
'A' server is is publisher. B is local server subscriber.There is snapshot replication from A to B for one table.
Data is replicating from 'A' to 'B'.
In Server 'B', we have a table tbl_main this table is getting data from server 'A' table tbl_main.
I have a trigger (ins,upd,del) trigger on tbl_main in 'B' server . But this trigger is not firing when replication agent ins/upd/del record on the table.Pls tell me where i am doing the mistake? What is the solution?
🙂
Thanks
Ramaa
October 20, 2010 at 4:28 am
Snapshot replication get does not ins/upd/del individual rows. It does bcp. By default bcp does not fire triggers.
October 20, 2010 at 7:02 am
Thank you Suresh for your info.
Ramaa
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply