xp_msver (Transact-SQL)

Applies to: SQL Server

Returns version information about 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.

Transact-SQL syntax conventions

Syntax

xp_msver [ 'optname' ]

Arguments

'optname'

The name of an option, and can be one of the following values.

Option or column name Description
ProductName Product name; for example, 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 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
SpecialBuild Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
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 set

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.