FIX: Error Message Should Be Clearer When There Are Multiple SELECTs in a Stored Procedure

• Microsoft SQL Server version 6.5

SYMPTOMS

In versions of SQL Server earlier than SQL Server 6.5 Service Pack 5, if you erroneously attempt to open a server cursor on a stored procedure that contains more statements than a single SELECT statement, you will receive the following somewhat incomplete error message:

Cannot open a cursor on a stored procedure that has anything other than a single select statement in it.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

The error message is accurate, but it does not provide complete information to allow the developer to address the error.

Based on customer feedback, this error message has been changed to be clearer. With SQL Server 6.5 Service Pack 5, the error message now reads:

A server cursor is not allowed on a stored procedure with more than one SELECT statement. Use a default result set or client cursor.

Additional query words: prodsql st sproc

Keywords          : kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 4, 1999