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

  • October 16, 2013 at 1:04 am

    #1658801

    I also encounter this now and then, but with not any specific regularity.

    EXEC sp_RefreshView '<View that reverences a linkedserver table>' will also allow the view to be used.

    Has anyone encountered this with a view that uses SchemaBinding?

    None of my views that generate this message use schemabinding.

    Cheers


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort