I have a SQL Server 7 linked to a SQL Server 2000. When connecting to the SQL2000 Query Analizer and making a SELECT statement against a SQL7 table, the following error appears:
"OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time."
Five out of Six SELECT statements work fine (each for a different table). But a sixth table always throws this error. Even a SELECT TOP 1 statement throws an error. When connecting directly to the SQL7, all the 6 statements work fine.