|
Home > Archive > MS SQL Server DTS > January 2006 > Cursors and DTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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@Z-Zvolution.nZt> wrote in message
news:O6kCBJVIGHA.532@TK2MSFTNGP15.phx.gbl...
> 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
>
|
|
|
|
|