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

14,820 reads

Blogs

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs

Forums

SQL help with partition

By don075

With the following data, I need to create a column that will display a...

How can I show the last opening period for each project in my project dimension

By casagrandi

I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...

Upgrading from 2016 to 2019 with Encryption

By Richard Warr

Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers