xp_msver (Transact-SQL)

Returns version information about Microsoft SQL Server. xp_msver also returns information about the actual build number of the server and information about the server environment. The information that xp_msver returns can be used within Transact-SQL statements, batches, stored procedures, and so on, to enhance logic for platform-independent code.

Topic link iconTransact-SQL Syntax Conventions

Syntax

xp_msver [ optname ]

Arguments

  • optname
    Is the name of an option, and can be one of the following values.

    Option/Column name Description

    ProductName

    Product name; for example, Microsoft SQL Server.

    ProductVersion

    Product version.

    Language

    The language version of SQL Server.

    Platform

    Operating-system name, manufacturer name, and chip family name for the computer that is running SQL Server.

    Comments

    Miscellaneous information about SQL Server.

    CompanyName

    Company name that produces SQL Server; for example, Microsoft Corporation.

    FileDescription

    The operating system.

    FileVersion

    Version of the SQL Server executable.

    InternalName

    Microsoft internal name for SQL Server; for example, SQLSERVR.

    LegalCopyright

    Legal copyright information required for SQL Server; for example, Copyright© Microsoft Corp. 1988-2005.

    LegalTrademarks

    Legal trademark information required for SQL Server. For example, Microsoft is a registered trademark of Microsoft Corporation.

    OriginalFilename

    File name executed at SQL Server startup; for example, Sqlservr.exe.

    PrivateBuild

    Reserved.

    SpecialBuild

    Reserved.

    WindowsVersion

    Version of Microsoft Windows that is installed on the computer that is running SQL Server.

    ProcessorCount

    The number of processors in the computer that is running SQL Server.

    ProcessorActiveMask

    Indicates the processors installed in the computer that is running SQL Server that are started and usable by Microsoft Windows.

    ProcessorType

    Processor type. Similar to Platform.

    PhysicalMemory

    Amount in megabytes (MB) of RAM installed on the computer that is running SQL Server.

    Product ID

    Product ID (PID) number. This is specified during installation. This number is located on a sticker on the original SQL Server CD case.

Return Code Values

1 (success)

Result Sets

xp_msver, without any parameters, returns a four-column result set that lists all the option values. xp_msver, for any parameter, returns the four-column result set with values for that option.

Permissions

Requires membership in the public role.

See Also

Reference

System Functions (Transact-SQL)
System Stored Procedures (Transact-SQL)
General Extended Stored Procedures (Transact-SQL)
@@VERSION (Transact-SQL)
SERVERPROPERTY (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance