xp_msver system procedure

Retrieves version and name information about the database server.

Syntax 
xp_msver( string )

  • string   The string must be one of the following, enclosed in string delimiters.

    Argument Description
    ProductName The name of the product (SQL Anywhere).
    ProductVersion The version number, followed by the build number. The format is as follows: 
    11.0.0.3512
    CompanyName Returns the following string: 
    iAnywhere Solutions, Inc.
    FileDescription Returns the name of the product, followed by the name of the operating system.
    LegalCopyright Returns a copyright string for the software.
    LegalTrademarks Returns trademark information for the software.

Remarks

xp_msver returns product, company, version, and other information.

Permissions

None

See also
Example

The following statement requests the version and operating system description:

SELECT xp_msver( 'ProductVersion') Version,
   xp_msver( 'FileDescription' ) Description;

Sample output is as follows:

Version Description
11.0.0.3512 SQL Anywhere Windows XP
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0