By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,268 Members | 1,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,268 IT Pros & Developers. It's quick & easy.

Could not complete cursor operation because the table schema changed after the cursor was declared

P: n/a
Hi,

My stored procedure was working fine but when i made added 2 fields to my
table and then made subsequent changes to my sp it give me the following
error:

"Could not complete cursor operation because the table schema changed after
the cursor was declared"

it works fine from back end (query analyser) but when i execute from my dot
net code it give the above error.

does anyone help please ?
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Are you using ADO.NET or ADO v 2.x? Can you post the code you're using?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Ajit" <ad******@thedebtmediator.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hi,

My stored procedure was working fine but when i made added 2 fields to my
table and then made subsequent changes to my sp it give me the following
error:

"Could not complete cursor operation because the table schema changed after the cursor was declared"

it works fine from back end (query analyser) but when i execute from my dot net code it give the above error.

does anyone help please ?

Nov 21 '05 #2

P: n/a
Dim oCmd As SqlCommand
oCmd = New SqlCommand("sp_processWeeklytask", oConn)
oCmd.CommandType = CommandType.StoredProcedure
oCmd.CommandTimeout = 0
oCmd.ExecuteNonQuery()

I am using ADO.Net

"W.G. Ryan eMVP" <Wi*********@gmail.com> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...
Are you using ADO.NET or ADO v 2.x? Can you post the code you're using?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Ajit" <ad******@thedebtmediator.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hi,

My stored procedure was working fine but when i made added 2 fields to my table and then made subsequent changes to my sp it give me the following
error:

"Could not complete cursor operation because the table schema changed

after
the cursor was declared"

it works fine from back end (query analyser) but when i execute from my

dot
net code it give the above error.

does anyone help please ?


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.