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

  • Thread starter Thread starter Ajit
  • Start date Start date
A

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 ?
 
Dim oCmd As SqlCommand
oCmd = New SqlCommand("sp_processWeeklytask", oConn)
oCmd.CommandType = CommandType.StoredProcedure
oCmd.CommandTimeout = 0
oCmd.ExecuteNonQuery()

I am using ADO.Net
 
Back
Top