Microsoft KB Archive/154644

= INF: Running SQL Server 6.5 INSTCAT.SQL on SQL Server 6.0. =

Article ID: 154644

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q154644



SUMMARY
When you run INSTCAT.SQL included in SQL Server 6.5 on SQL Server 6.0, an error message appears which indicates that procedure sp_MS_upd_sysobj_category does not exist. You may ignore this message.



MORE INFORMATION
The procedure sp_MS_upd_sysobj_category in SQL Server 6.5 replaces the procedure sp_check_objects in SQL Server 6.0. When you run sp_MS_upd_sysobj_category on SQL Server 6.0, the SQL Server 6.5 INSTCAT.SQL runs sp_check_objects if it is present. This indicates that the correct processing is done on SQL Server 6.0. INSTCAT.SQL successfully completes all necessary processing against SQL Server 6.0 without sp_MS_upd_sysobj_category.

For some users who notice that the error may find that sp_MS_upd_sysobj_category is created by the UPGRADE1.SQL script in the SQL Server 6.5 \mssql\install directory, and attempt to run UPGRADE1.SQL against SQL Server 6.0. This is not necessary. In addition, UPGRADE1.SQL does not complete successfully against SQL Server 6.0.

Additional query words: 2.65.0201 6.0 6.5

Keywords: kbnetwork KB154644

-

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

© Microsoft Corporation. All rights reserved.