November 1, 2018 at 9:47 am
Reo - Tuesday, August 30, 2016 7:21 PMIssue : Error "reported a change in schema version between compile time" when queering LinkServer (Remote table).Solution : Please set LinkServer property "Lazy Schema Validation" to FALSEIf this option is set to false, the default value, SQL Server checks for schema changes that have occurred since compilation in remote tables. This check occurs before query execution. If there is a change in the schema, SQL Server recompiles the query with the new schema.If this option is set to true, schema checking of remote tables is delayed until execution. This can cause a distributed query to fail with an error if the schema of a remote table has changed between query compilation and execution.http://msdn.microsoft.com/en-us/library/ms190918.aspx
This is the exact issue I've been having for months. No idea why internet searching a many, many different ways didn't lead me to this until now. Thank you for your answer to this issue.
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy