To support reporting of schema data, SQL Server client interfaces rely on system stored procedures that extract data from a server’s catalog. As client software evolves, the catalog stored procedures also evolve.
When a SQLOLEDB consumer connects to an older version of SQL Server (4.21a, 6.0, or 6.5), SQLOLEDB returns an informational error message stating the catalog stored procedures are out of date.
SQLOLEDB is compatible with older versions of SQL Server. However, not all schema rowsets are supported on older versions of SQL Server unless the catalog stored procedures are upgraded to the current release level.
To upgrade the catalog stored procedures, use an appropriate client utility to run the Transact-SQL Instcat.sql script that ships with the most recent version of SQLOLEDB. Instcat.sql requires system administrator privilege.
Depending on the version of the server, Instcat.sql execution can generate many error messages. All generated errors can be safely ignored if the final line of execution output indicates success.