Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2013-05-21 : 04:36:09
|
| Hi, I am running a job on my published database. The job executes few lines of code which selects records from a table writes into a txt file. Am using cursor to traverse the record set. At some point the job is stopping (failing) with the message"Could not complete cursor operation because the table schema changed after the cursor was declared"Any idea about the issue.Thanks in advance,Shobha |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-21 : 05:03:54
|
| the error message is obvious. Are you doing any DDL operations inside your cursor?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
lrosales@shimee.com
Starting Member
3 Posts |
Posted - 2013-05-31 : 13:33:16
|
| firs what version of SQL Server I you using? |
|
|
|
RickCox
Starting Member
1 Post |
Posted - 2013-08-22 : 08:48:43
|
quote:
Originally posted by shobhaaradhya
Hi, I am running a job on my published database. The job executes few lines of code which selects records from a table writes into a txt file. Am using cursor to traverse the record set. At some point the job is stopping (failing) with the message"Could not complete cursor operation because the table schema changed after the cursor was declared"Any idea about the issue.Thanks in advance,Shobha
Bulk insertion of data using package from one database to other , sometimes gives this kind of error. If any query is going to alter the Table that you should use trigger.business phone providers |
|
|
|
|
|
|
Could not complete cursor operation