Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
polymorph
Starting Member
2 Posts |
 Posted - 2006-01-25 : 09:15:40
|
| Hi,I've implemented transactional replication (from publisher to subscriber only) between two databases on the same SQL Server instance. The subscriber tables have triggers which insert details into another table which is not part of replication and which only exists on the subscriber.I've replicated about 8 tables with horizontal filtering on some of the tables. Replication works perfectly on all of the tables but the subscriber trigger does not fire when replicating to one particular table, although the table is updated through replication.I can't think of any reason why this should happen as it works perfectly for all other tables. The update trigger on the problem table does not use the WITH ENCRYPTION or NOT FOR REPLICATION commands.There is no information in the event log, SQL server logs or replication alerts which indicate that an error is occurring.I'm aware that triggers are disabled when the initial snapshot is being applied. The snapshot agent has finished running so this cannot be the cause of the problem.Thanks |
|
|
polymorph
Starting Member
2 Posts |
Posted - 2006-01-25 : 09:22:45
|
Should have mentioned that I'm using SQL Server 2000 on Windows 2000 Server  |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-25 : 21:11:55
|
| check the following:1. running snapshot drops the subscriber tables - everytime this happens, you need to recreate the trigger2. since there is a trigger on a subscriber table, check if there are errors encountered during the insert from subscriber table to another table - the error will rollback the changes from the target table all the way up to the article (publisher), from experience, this type of error sometimes isn't logged. You need to observe this by simulating the insert transaction not by trigger but manually inserting the values similar to the data from subscriber table (as is)HTH--------------------keeping it simple... |
|
|
|
|
|
|
Transactional Replication