Hangfire with MSSQL Merge Replication

question
1

Hi there!

Is it possible to apply Merge Replication for the hangfire tables in MSSQL?
We are currently getting the following error message:

‘The target table ‘JQ’ of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.’

The merge replication creates three triggers (INSERT/UPDATE/DELETE) on each table, which can’t be used with the OUTPUT clause used by Hangfire.SQLServer.

In the desired situation, we would like to run Hangfire on the main database and the replicated database.

Is there a solution or work around for this problem, or is it maybe impossible?

3

Hey, I realize this is a really old post, but I have ran into the same problem and this is about the only information about this I can find online… Did you every find a solution or did you abandon Hangfire?