Upgrading the Catalog Stored Procedures (OLE DB)

OLE DB and SQL Server

OLE DB and SQL Server

Upgrading the Catalog Stored Procedures (OLE DB)

The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) uses a set of system stored procedures known as catalog stored procedures to obtain information from the system catalog. Microsoft® SQL Server™ 2000 installs the catalog stored procedures automatically when you install or upgrade an instance of SQL Server. The Instcat.sql file included with this provider includes updates to the catalog stored procedures. If this version of SQLOLEDB will be used with SQL Server version 6.5, the SQL Server system administrator must upgrade the catalog stored procedures on the earlier instance of SQL Server by running Instcat.sql. Upgrading the catalog stored procedures does not affect the operations of SQL Server clients.

To upgrade the catalog stored procedures