Home Forums SQL Server 2005 Development The OLE DB provider "SQLNCLI" for linked server "X" reported a change in schema version between compile time RE: The OLE DB provider "SQLNCLI" for linked server "X" reported a change in schema version between compile time

  • On my side, the error occurs every Monday morning after the rebuild of indexes and stats. So, maybe removing the autostats update and put that on a schedule and after that job is done, then do a drop and re-create of synonyms would be a better workaround.

    We've been talking with an engineer from MS on this issue, and they've seen the error and confirmed that the patch that supposedly fixes it is installed too. But, there is a 3rd party SQL box that is a target of the synonyms that wasn't patched, so we're in the process of getting okays from JDE that they will support that patch and if so, then we'll see if that solves the problem.

    From what I've seen, all the servers (target and consumer of synonyms) need to have this patch installed, not just the server where the error is occurring.

    Hope that helps.