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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-01-31 : 09:00:06
|
Matthew writes "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.Many ThanksMatt" |
|
|
|
|