PRB: Some SQL Server 7.0 Service Pack 2 Updates Must be Added Manually (266337)
The information in this article 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).
| Modification Type: | Minor | Last Reviewed: | 7/16/2004 |
|---|
| Keywords: | kbprb KB266337 |
|---|
|