An question on trigger and transactional replication

Last Post 22 Aug 2006 12:11 AM by bchu1981. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bchu1981
New Member
New Member

--
22 Aug 2006 12:11 AM
Dear all,

Further to my replication assignment, I notice there are some triggers on some tables and this may make the scenario more complicated. I encounter a situation which I can't understand very well.

Say, there are two database A and B. DB A contains two tables c and d, while DB B contain two tables e and f. Table c is with the same structure with e and table d is with the same structure with f. DB A is the publisher (with aritcles of tables c and d) and DB B is the subscriber (subscribing tables e and f). There is a trigger in table c. It will insert an record into table d whenever there is an insert into table c. There is no such trigger in table e.

The interesting scenario is as follows. I insert an record in table e, and it is replicated to table c. Thanks to the trigger, it will insert an record in table d. However, not as I expected, the new record in table d will NOT be replicated to table f. If I directly insert an record into table d, it will be replicated to table f.

I enable nested trigger and disable recursive trigger.

Can any one explain this? Thanks!

bchu
You are not authorized to post a reply.

Acceptable Use Policy