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

  • Exactly!, I have a view as table name. But I have spoke with Microsoft regarding this and they accept that this is a bug in SQL which they are not about to fix anytime soon. So, I had to use sp_recompile and/or sp_refresh to be able to get those two table linked and be able to use them. I didn't like the temporary fix but I have to go on with it for my clients to be able to access the database.

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]