1
kudos
spam Kudos Remove

SQL Server 2008 R2: OLE DB provider "SQLNCLI10" for linked server "x" reported a change in schema version between compile time and run time
published 195 days, 9 hours, 2 minutes ago posted by sasa 200 days, 10 hours, 42 minutes ago
Wednesday, November 09, 2011 2:04:04 AM GMT Friday, November 04, 2011 12:24:23 AM GMT
SQL Server 2008 R2: OLE DB provider "SQLNCLI10" for linked server "x" reported a change in schema version between compile time and run time
The OLEDB provider for the linked server reported a change in schema version between compile time and execution time. For a moment the error throws out spanner in works, application stalls and complaints about timeout issues. A search on forums reveals its a real problem when you perform changes to table schema with REORG or column change in an object. A REORG is quite common on a production environment but not that schema changes, which is managed as a seperate implementation. See this SQLConnect...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: compile time, cumulative update, driver, execution time, kba, linked server, maintenance plan, oledb, schema changes, service pack, SQL Server

No comments yet, be the first one to post comment.

To post your comment please login or signup