Upgrading the Catalog Stored Procedures

The SQL Server driver uses a set of system stored procedures, known as catalog stored procedures, to obtain information from the SQL Server system catalog. Microsoft 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. Having the SQL Server system administrator upgrade the catalog stored procedures on a server running Microsoft SQL Server 4.21a or 6.0 is required.

To upgrade the catalog stored procedures, the system administrator runs a script using the isql utility (see the instructions below). Before making any changes to the master database, the system administrator should back it up. To run isql, your computer must be installed as a client workstation for Microsoft SQL Server.

    To upgrade the catalog stored procedures
sa_password
Is the system administrator's password.
server_name
Is the name of the server on which SQL Server resides.
location
Is the full path of the location of INSTCAT.SQL. You can use INSTCAT.SQL from an installed SQL Server 6.5 (the default location is C:\MSSQL\INSTALL) or from the SQL Server 6.5 CD (the default location is D:\platform where D is the CD drive letter and platform is the appropriate server platform directory, such as I386).

The INSTCAT.SQL script generates messages. Ignore these.

The INSTCAT.SQL script fails when there is not enough space available in the master database to store the catalog stored procedures or to log the changes to existing procedures. If the INSTCAT.SQL script fails, contact your system administrator.

The SQL Server driver uses the following catalog stored procedures.

Stored procedure Returns
sp_column_privileges Information about column privileges for the specified table(s)
sp_columns Information about columns for the specified table(s)
sp_databases A list of databases
sp_datatype_info Information about the supported datatypes
sp_fkeys Information about logical foreign keys
sp_pkeys Information about primary keys
sp_server_info A list of attribute names and matching values for the server
sp_special_columns Information for a single table about columns in the table that have special attributes
sp_sproc_columns Column information for a stored procedure
sp_statistics A list of indexes for a single table
sp_stored_procedures A list of stored procedures
sp_table_privileges Information about table privileges for the specified table(s)
sp_tables A list of objects that can be queried

For additional information about the catalog stored procedures, see What's New in SQL Server 6.5 and the Microsoft SQL Server Transact-SQL Reference.