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 LineNumberA severe error occurred on the current command. The results, if any, should be discarded
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.