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

  • In my case the "tablename" the error was referring to was a table that i had a pass-through view to from the local db. What I mean is, my app had a view called (e.g.) "User". That view was a "select * from User_Table_In_Another_Db".

    When I changed deployment environments (moving the local db into an environment where the view was now reading from a different instance of "other_Db"), the view had apparently retained some kind of version information from the first "other_Db" it was looking at.

    Recompiling the views solved the problem. However, the reason I'm out here looking for people who are experiencing the issue is... for whatever reason, the error has resurfaced. I don't have direct access to the DBs, as I am in a consulting role, remote, and they won't allow it. But they say they haven't changed anything about the schema in "other_Db" since we fixed the issue by recompiling the views.

    So now I'm puzzled again. But I thought, if your "tableName" was a view you could try this.