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

  • February 25, 2013 at 11:04 am

    #1590894

    Glen Sidelnikov (9/25/2008)

    There is one more scenario. It is using synonyms in SQL 2005.

    In this case this is "granted by design". You need to recreate synonym if the table on which synonym was based changed.

    Ah hah, this was my issue. Thank you, Glen!

    I had a synonym on a table; used Red Gate's data compare to synchronize data between test & production tables which dropped indexes and recreated them... which broke the synonym. Recreating the synonym fixed this error for me.