INF: Running SQL Server 6.5 INSTCAT.SQL on SQL Server 6.0. (154644)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbnetwork KB154644
©2003 Microsoft Corporation. All rights reserved.