Replication error

[jonnyk]

A replication agent running from one SQL Database to another on the same SQL 2000 server throws up the following error every night. No major processors are happening at this time

Any Advice


SQL error occurred. See entry specific information. Error : 16943, 37000, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.

 

[oublie]

your definately running SQL 2000? The reason I ask is microsoft report this error as a fault with SQL 7 see the following link for details.

http://support.microsoft.com/default.aspx?scid=kb;en-us;232522

 

[jonnyk]

I have seen this report and yes I am definately on SQL 2000