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

Applies to: 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

 

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.