Upgrading the Catalog Stored Procedures (ODBC)

The Microsoft® SQL Server™ ODBC driver uses a set of system stored procedures, known as catalog stored procedures, to obtain information from the SQL Server system catalog. SQL Server installs the catalog stored procedures automatically when you install or upgrade SQL Server. The Instcat.sql file included with this driver includes minor updates to the catalog stored procedures. If this version of the SQL Server ODBC driver will be used against SQL Server version 6.5 or earlier versions, the SQL Server system administrator must upgrade the catalog stored procedures on the earlier SQL Server. Upgrading the catalog stored procedures does not affect the operation of existing SQL Server clients.

Running the SQL Server 2000 ODBC driver against an earlier version of SQL Server that has earlier versions of catalog stored procedures generates an error:

The ODBC catalog stored procedures installed on server <server_name> are 
version <old_version_number>; version <new_version_number> or later is 
required to ensure proper operation. Please contact your system 
administrator.

To upgrade the catalog stored procedures