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 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.