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.
2002-02-28
14,389 reads
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
2001-05-30
3,318 reads
If you use performance log data and need to conduct time-sensitive analysis, watch out for this little feature in Windows 2000.
2001-05-15
3,037 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
Hi guys I have a query with a SELECT statement, that joins 2 other...
Hi all, Can someone please help Pivot a table. The table currently looks like...
Hello Community, Can someone please help transpose a table. The table currently looks like...
Ask SSC