SQL Server 2008: What is lazy schema validation?

sql-server-2008 linked-server
Bill picture Bill · Dec 15, 2010 · Viewed 9.2k times · Source

Saw this option when I made a linked server

Answer

vee_ess picture vee_ess · Dec 15, 2010

Basically it just enables you to improve performance for remote tables by not requesting meta data for each request, only when data is actually needed from the tables.

Lazy Schema Validation:

If 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

Related questions

"Deferred prepare could not be completed" error when using local database as linked server

I created a Linked Server from my local Sql Server, as given in http://sqlserverplanet.com/dba/local-linked-server However when I try to execute a stored procedure in Linked Server, it throws: Deferred prepare could not be completed error and …

Read More
Run a Query from Linked Server (Oracle) in SQL Server2008 R2

I have the linked server set up in SQL Server 2008. But I could not run any query against the linked server. I tried to run this simple command but it's not working SELECT * FROM MYSERVER..ALANH.TEMP_UPDATE1 This is …

Read More
How to find which OLE provider is available for SQL Server?

I try to access an Excel file in SSMS. After searching the internet, I could not get it working. Here is what I did: My environment: Windows 7(64bit) SP 1, Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Office 2010 Pro Plus with Access …

Read More