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

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:
Recommendation: Install the latest cumulative update for 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.
属性

文章 ID:3155209 - 上次审阅时间:2016年8月16日 - 修订版本: 1

反馈