SQL Server Performance

Error In DTS - sql task execution.

Discussion in 'General DBA Questions' started by a_lateef, Nov 26, 2002.

  1. a_lateef New Member

    Error Source : Microsoft OLE DB Provider for SQL Server

    Error Description : Could not complete cursor operation because the table schema changed after the cursor was declared.

    -----> This is the error i received when i executed the SQL task from dts designer. But the execution is happened properly and completed till the end of program. I wonder now with this message.. What is the problem.. Kindly someone help me.

    Abdul Lateef.
    Polaris Software Labs.
    001 91 44 4341964.
  2. satya Moderator

    You may try using the profiler on your database to see what queries are executing at the time you receive the error, this was how I was able to find the problem.

    Also make sure no other process accessing the same table process.

    HTH

    Satya SKJ

Share This Page