Microsoft Fixes Invalid Cursor State

Microsoft has released a hotfix for an invalid cursor state that occurs after you apply hotfix build versions between 8.00.0859 and 8.00.0875 in SQL Server 2000 Service Pack 3 (SP3). Applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets following an informational message, a RAISERROR statement, or a PRINT statement, might have various failures in processing results. The error message differs depending on what client API you're using. Common error messages include "ADO: Operation is not allowed when the object is closed" and "ODBC: [Microsoft][ODBC SLQ Server Driver]Invalid cursor state." This bug also affects the Design Table feature in Enterprise Manager. To learn more about the problem and the supported hotfix, read the Microsoft article "FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000" at

   http://support.microsoft.com/?kbid=831997