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


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'.


The issue was first fixed in the following cumulative updates of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server


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


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

문서 ID: 3155209 - 마지막 검토: 2016. 8. 16. - 수정: 1