SQL schema version changed between compilation execution
Posted: Thu Dec 01, 2005 9:39 am
BB
Regular
Joined: Jun 23, 2004
Posts: 340
Using Microsoft SQL Server 2000. You may see this strange type of error. This is the OLE DB error reported from an ASP.NET web page
Quote:
The OLE DB provider 'SQLOLEDB' reported a schema version for table '"{your table here}"' that changed between compilation and execution. OLE DB error trace [Non-interface error: Schema version number changed from compile time ({number}) to run time ({new number}) for ProviderName='SQLOLEDB' TableName='"{your table here}"'.].
The 7359 error indicates that the schema has changed since compilation.
Microsoft SQL Server has an option "lazy schema validation". If this option is ON (default OFF), SQL Server postpones the execution time
check as to whether the schema of a table has changed between compilation and execution of a stored procedure. Postponing the check causes performance improvements in cases when a given remote table is not actually used in the query (e.g. in partitioned view against remote table scenario); this may however cause a query to abort in the middle of execution if the schema has indeed changed since compilation.
This problem typically occurs on stored procedure queries from one linked SQL server to another separate SQL server.
The article can be found in the MSDN library at:
MSDN Home > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2000 > Managing Servers > Configuring Linked Servers
Moved up to main Group29 page
Posted: Tue Feb 26, 2008 5:41 am
BB
Regular
Joined: Jun 23, 2004
Posts: 340
This story has been bumped up to the Group29 Main page.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest (c) 2006 by Group29 Productions.
You can syndicate Group29 Productions news with an RSS Feeder using the file backend.php
