Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Retrieves version and name information about the database server.
xp_msver( the_option )
The string must be one of the following, enclosed in string delimiters.
The version number, followed by the build number. The format is as follows:
Returns the following string:
iAnywhere Solutions, Inc.
xp_msver returns product, company, version, and other information.
The following statement requests the version and operating system description:
SELECT xp_msver( 'ProductVersion') Version,
xp_msver( 'FileDescription' ) Description;
Sample output is as follows. The value for Version will likely be different on your system.