How do you close a cursor in SQL 2000 in production?
Posted on 2008-10-02
We have a VB6/SQL Server 2000 app running. We got the "A cursor with the name of ... already exists' error. After that, we've been getting an 'Unspecified Error' error message from the same process. Assuming that the new errors come from the open cursor, how do we close down the cursor on our production machine?
As for the code, I'm fixing the underlying problem, it did not close and deallocate the cursor when errors might occur.