Article ID: 255097 - View products that this article applies to.
This article was previously published under Q255097
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57407 (SQLBUG_70)
When you attempt to execute a distributed query, against a view on a remote linked server, the query fails with the following message:
If you have trace flag 7300 enabled for extended OLE DB messages, you may also see something similar to the following (the object name may be different):
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
This problem occurs if:
OLE DB error trace [Non-interface error: Column 'derived' (compile-time ordinal 1) of object '"pubs"."dbo"."vwTest"' was reported to have a PRECISION of 2 at compile time and 3 at run time].
To work around this problem, try either of the following: