How can I check if a cursor is already open ? What I want to do is to call
the stored procedure many times and each time just retrieve a certain number
of rows. The tric here is to don't close the cursor. In Oracle you can use
the identifier it <cursorname%ISOPEN>.
Can this also be done in SqlServer 6.5 ?
Hope to hear some info soon,
Marcel van Velzen