ACC: How to Determine Version of INSTCAT.SQL File on Server

MORE INFORMATION

The following syntax can be executed in a pass-through query in Microsoft Access 2.0, 7.0 and 97 as well as in the Query window of SQL Server Administration Facility (SAF) for MS-DOS, OS/2, Microsoft Windows or any other operating system in which you can execute a stored procedure:

   sp_server_info 500
				

The attribute_value field of the returned row contains the version number. If an empty recordset is returned, it is likely that the INSTCAT.SQL file was not run on the server. The result will resemble the following:

   attribute_id   attribute_name      attribute_value
   --------------------------------------------------
   500            SYS_SPROC_VERSION   01.00.2101
				

OS/2 is manufactured by International Business Machines Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.