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

[Ajit]

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 ?

 

[W.G. Ryan eMVP]

Are you using ADO.NET or ADO v 2.x? Can you post the code you're using?

 

[Ajit]

Dim oCmd As SqlCommand
oCmd = New SqlCommand("sp_processWeeklytask", oConn)
oCmd.CommandType = CommandType.StoredProcedure
oCmd.CommandTimeout = 0
oCmd.ExecuteNonQuery()

I am using ADO.Net