FIX: Error occurs when you drop a subscription by using a non-sysadmin account in SQL Server

Gilt für: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Enterprise Core

Symptoms


When you drop a subscription by using an account that's not a member of the SQL Server sysadmin fixed server role in Microsoft SQL Server, although the subscription is dropped successfully, you may receive an error message that resembles the following:

The Subscriber was dropped.

Msg 0, Level 11, State 0, Line LineNumber

A severe error occurred on the current command.  The results, if any, should be discarded

 

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 6 for SQL Server 2016 RTM

       Cumulative Update 3 for SQL Server 2016 SP1

       Cumulative Update 5 for SQL Server 2014 SP2

       Cumulative Update 12 for SQL Server 2014 SP1

       Cumulative Update 8 for SQL Server 2012 SP3

 

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.