Bugs

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)

2002-02-28

12,743 reads

Blogs

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

Azure SQL Database – Automatic Tuning – Have you enabled it?

By

Do you enable this setting to allow automatic tuning to care of all your...

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Read the latest Blogs

Forums

is there any better way to export SQL server data into csv file?

By 892717952

I have  questions of exporting SQL server data, the details as below, thanks! how...

Uninstall SQL without uninstalling SSRS

By Brandie Tarvin

We have a non-prod server that (long ago) we installed SQL Server on and...

Some SP\'s performing slow when Database upgraded to SQL 2017 compatability

By khushbu

Few reports are run which uses source db which was upgraded to SQL 2017...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers