SQL Server 7.0: cursor errors - TechRepublic
General discussion
May 13, 2001 at 08:50 PM
hilary

SQL Server 7.0: cursor errors

by hilary . Updated 24 years, 11 months ago

I was wondering if someone out there could help me with the following SQL message I haven’t been able to get to the bottom of:

Server: Msg 16915, Level 16, State 1, Procedure procedure_name, Line 54
A cursor with the name ‘procedure_name’ already exists.
Server: Msg 16905, Level 16, State 1, Procedure procedure_name, Line 58
The cursor is already open.

I’ve always checked that the cursor has been closed AND deallocated and at one stage I thought it could be a result of fetching too many variables in a cursor but it can even happen when it’s only fetching one variable .. and the stored proc still appears to run after this message appears.

Thanks, any help would be appreciated!!

This discussion is locked

All Comments