http://www.sqlservercentral.com/Articles tagged Administering, SQL Server 7, 2000, Bugs posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it. http://www.sqlservercentral.com/articles/Bugs/changingcolumn/618/2002/02/28http://www.sqlservercentral.com/articles/Bugs/changingcolumn/618/