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

13,058 reads

Blogs

Publish ADF from code to further environments

By

Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...

Getting the Proc Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Running SQL Server in Google Cloud Platform

By

On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...

Read the latest Blogs

Forums

How to efficiently perform search on my DB and Word documents on my server?

By umeshamin

So I'm building a system for a client and they want to have a...

Copy Azure SQL DB App data to Azure Synapse

By DataBanker

Hello, I am looking for the best way to copy change data from my...

Enable normal user to execute a sys stored procedure

By SZ

I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers