title: Linked SQL Server database giving "inconsistent metadata" error
body: <p>I am currently running a third-party software suite, which uses SQL Server as its database.  I have a second instance of SQL Server running in a different location, and some apps that I am building in that instance SQL Server needs to access some data in the third-party software.  So, I created an ODBC connection between the boxes, and set up the third-party SQL server as a linked server on my version of SQL Server.  As a test, I ran something like the following statement from my SQL server, accessing one of the third-party's tables:</p>
  
  <pre><code>SELECT * FROM LinkedServerName.SchemaName.dbo.TableName
  </code></pre>
  
  <p>To which I recieved this error:</p>
  
  <pre><code>OLE DB error trace [Non-interface error:  Column 'TableRowVersion' (compile-time
  ordinal 4) of object '"SchemaName"."dbo"."TableName"' was reported to have a
  DBCOLUMNFLAGS_ISROWVER of 0 at compile time and 512 at run time].
  
  Msg 7356, Level 16, State 1, Line 1
  
  OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column. Metadata
  information was changed at execution time.
  </code></pre>
  
  <p>This error is the same for any other table I try to access.  What does this error mean, and is there a way around it?</p>