Microsoft KB Archive/266337

= PRB: Some SQL Server 7.0 Service Pack 2 Updates Must be Added Manually =

Article ID: 266337

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Service Pack 2

-



This article was previously published under Q266337



SYMPTOMS
Some bugs, which are marked as fixed in Microsoft SQL Server 7.0 Service Pack 2, still occur after you apply Service Pack 2. These bugs all involve fixes to system database objects, not to executables or DLL files.

Error messages for this issue can include, but are not limited to:

Server: Msg 7353, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.



CAUSE
All updates to system stored procedures should be in Sp2_serv.sql, but some are not. Some of the updates to the system stored procedures are in the Instcat.sql file. However, Instcat.sql is not run from the Service Pack 2 setup. Therefore, any Service Pack 2 fixes that involve updates to catalog stored procedures, are not applied.



WORKAROUND
To work around this problem, manually run the Instcat.sql file, which comes with SQL Server 7.0 Service Pack 2 (not the Instcat.sql in the \Mssql7\Install folder). You can run the Instcat.sql file from Query Analyzer, ISQL, or OSQL while you are logged in as system administrator (sa).



MORE INFORMATION
For additional information about a bug fix that needs a manual run of the Instcat.sql file, see the following article in the Microsoft Knowledge Base:

243027 FIX: Numeric Column in Oracle Causes Error 7354

Additional query words: sp2 linked server

Keywords: kbprb KB266337

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.