Severe Error Occurred - SQL Server

Error Message

When executing a stored procedure, you get the following error.

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

Cause

One cause is putting a RETURN statement while a transaction is pending.

Resolution

Be sure to either commit or rollback any pending transaction before every RETURN statement in a stored procedure.