SQL Server 2012. Database is in merge replication, no conflicts presented. Current example is simply for understanding, but real schema is very huge to describe. Schema and trigger at SQLFiddle for clear view.
Database has two tables
Store is in replication and has actual data.
Debug is outside of replication and presents only on publisher (no need to debug subscribers).
Store has trigger which activates at every delete query and dumps current time to
While debugging some queries in trigger I realized that any query that matches the insert/update/delete in trigger are transferring to subscribers. As described above subscribers don't have the table
Debug. While SQL Server Agent synchronize it catches a lot of conflicts about insert to this table:
Invalid object name 'Subscriber_dbname.dbo.Debug'.
I don't use
NOT FOR REPLICATION parameter for trigger because subscriber can delete row too and I need to catch this moment only on publisher. What can you suggest to avoid conflicts except having this table in every subscriber and creating dummy trigger for delete after insert having debug table always clean in any subscriber? Maybe there's any way to bypass insert/delete/update made from specific triggers?