FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016

Applies to: SQL Server 2016 EnterpriseSQL Server 2016 Enterprise CoreSQL Server 2016 Standard

Symptoms


Consider the following scenario:
  • In SQL Server 2012, 2014, or 2016, you use a filtered (row level) merge publication that has precomputed partitions enabled.
  • You don't have the ALTER TRACE permission.
  • You try to delete a record from the published table (on which the filter is present) by using a DELETE statement that doesn’t meet the filter criteria.
In this scenario, you receive an error message that resembles the following:
Msg 8189, Level 14, State 10, Procedure sp_repl_generateevent, Line 1
You do not have permission to run 'SP_TRACE_GENERATEEVENT'.

Resolution


The issue was first fixed in the following cumulative updates of SQL Server:

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.