Hi, I am using a cursor inside a stored procedure to do some complex work on
each row in a table.

Looking at the execution plan everything looks fine (Always worry about
cursors!!) and the Stored Procedure runs fine if I call it via Query
Analyser.

When I go to run the stored procedure from a DTS package (exec
MyStoredProcedure) I receive the following error message..

"The cursor is not open. Could not complete cursor operation because the set
operations have changed since the cursor was declared"

Any ideas how I can get around this??

TIA
Mark

Fixed the problem, my own fault, it was a problem with a SET DATEFORMAT
statement which I had (Stupidly) placed after the cursor had been declared.
Placing it before the declaration of the cursor fixed the problem

Mark

"Mark" <mark (AT) Z-Zvolution (DOT) nZt> wrote