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.

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

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