Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
BUG: Error 7356 from a Distributed Query
Article ID: 255097 - View products that this article applies to.
This article was previously published under Q255097
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: