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.


Note Running the SQL Server 7.0 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_nmbr>; version <new_version_number> or later is required to ensure proper operation. Please contact your system administrator.


To upgrade the catalog stored procedures

The SQL Server ODBC driver uses the following catalog stored procedures.

Stored procedure Returns
sp_catalogs List of all catalogs in a linked server. If the linked server is a server running SQL Server, the catalogs equate to databases.
sp_column_privileges Information about column permissions for the specified table(s).
sp_columns Information about columns for the specified table(s).
sp_databases List of databases.
sp_datatype_info Information about the supported data types.
sp_fkeys Information about logical foreign keys.
sp_pkeys Information about primary keys.
sp_linkedservers List of all linked servers defined on the local server.
sp_server_info List of attribute names and matching values for the server.
sp_special_columns Information for a single table about columns that have special attributes.
sp_sproc_columns Column information for a stored procedure.
sp_statistics List of indexes for a single table.
sp_stored_procedures List of stored procedures.
sp_table_privileges Information about table permissions for the specified table(s).
sp_tables List of objects that can be queried.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.