Tuesday, 14 July 2015

SQL: How To Fix "The OLE DB provider for linked server reported a change in schema version..."

Issue: After creating triggers on some tables with synonyms, in Lawlex when you go to a core document homepage, Lawlex returns an error: The OLE DB provider "SQLNCLI10" for linked server - something - reported a change in schema version between compile time - something- and run time for table - something -

Solution: Execute this in Query Analyzer to clear the cache

DBCC FREEPROCCACHE

No comments:

Post a Comment