Hello,

SQL Server verison on Publisher: 8.00.970
SQL Server verison on Subscriber: 8.00.970

An update proc containing two statements was issued on the subscriber. The
queue reader reports ODBC Error: Invalid cursor state.

I do not believe that Q831997 Applies here, because the symptoms published
under this article say:

"After you apply post-Microsoft SQL Server 2000 Service Pack 3 (SP3) hotfix
build versions between 8.00.0859 and 8.00.0875, 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, may have various failures in processing results....."

1) Is this assumption wrong?  My curent sql version is greater than .0875.  
SET NOCOUNT was OFF, no RAISERROR statement was present in the proc, and no
PRINT statement was present in the proc.

2) I have tried restarting the queue reader multiple times, and even
stopped/restarted the distribution agent.

3) Can I clean up the queue by running sp_MSreset_queue, and then mark the
article for resyncing via snapshot?  Does sp_MSreset_queue mark the whole
publication for resyncing via snapshot?

4) Is there a simple fix for this if Q831997 does not apply?

Thanks,

John T