Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

schema change error when accessing rows with computed columns

Here's the problem: I have several TSQL stroed procs that use a cursor on the
same table that has 4 computed columns. I also have several processes that
call these stored procedures to retrieve rows from the table and build a
string that is put into another table. The problem I am having is an
occasional error message from ADO that the schema has changed since the
cursor was openned (0x80040E14). My question is this: Can two separate
connections accessing the same row in the table with computed columns cause a
schema change error? I should also mention that the computed columns are
values that are generated by .NET CLR user defined functions.
Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc