Bugs

SQLServerCentral Article

How to Fix Inconsistent Metadata Errors

  • Article

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.

(1)

You rated this post out of 5. Change rating

2002-02-28

15,502 reads

Blogs

T-SQL Tuesday #193 - Notes to Self

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

T-SQL Tuesday #193 – Notes to my past self and from my future self

By

It has been a while since my last T-SQL Tuesday blog. When I saw...

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

Read the latest Blogs

Forums

What is the PRODUCT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the PRODUCT

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers