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.

5 (1)

You rated this post out of 5. Change rating

2002-02-28

15,438 reads

Blogs

The PASS Summit on Tour in the Netherlands

By

The PASS Summit goes on tour this year, with the final date the first...

Azure SQL Managed Instance: Boost Performance with Read-Scale Out

By

The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...

Free Cloud Environment Setup: A Beginner’s Guide

By

Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Sometimes, Troubleshooting Is Hard

By Grant Fritchey

Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard

Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension

By Hang Liu

Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...

Visit the forum

Question of the Day

The Updated Columns List

I have this table in SQL Server 2022:

CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
)
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers