Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Severe Error Occurred - SQL Server

RSS
Modified on Wed, Oct 22, 2008, 5:23 PM by Administrator Categorized as 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.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.