Anyone else run into bug in KB 2498818?

• dspeterson

  SSC-Addicted

  Points: 471

  More actions

  May 19, 2011 at 8:45 am

  #238397

  So we have a linked server setup, and will run into random issues pulling data through the linked server setup, getting this error:

  The OLE DB provider "SQLNCLI" for linked server "SERVER" reported a change in schema version between compile time ("A") and run time ("B") for table ""database"."schema"."tablename"".

  Stumbled across KB 2498818, which fits our situation exactly (using synonyms, blah blah blah) and indicates the bug is fixed in SQL Server 2008 SP2 CU3. I applied CU3 on the server that's pulling data via the linked server connection, but the issue still persists. We can replicate it by doing an index rebuild/reorg.

  Anyone else run into this bug? The article isn't quite clear, so before I spend the $$$ to call Microsoft, anyone have any thoughts on whether I would also need to patch the "source" server as well? That's unfortunately a bit more of an undertaking in terms of downtime, testing, etc. than just patching the server that's pulling the data.

  Thanks!

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 19, 2011 at 10:31 am

  #1327216

  Apparently others on this forum ra into this issue:

  http://www.sqlservercentral.com/Forums/Topic542765-145-1.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/