The root cause is that when the Franchise table is updated or inserted to, the merge triggers installed on the table by the replication, fire (the update trigger when there...

Yes the update needs to be made to the filter column since its a regular column of the table. Let me be more precise. The table in question is called...

Its a merge replication. The main table has a column that has the host_name filter applied to it. The ID colum which is a uniqueidentifier and PK is also the rowguidcolumn...