xp_msver
Returns and allows to be queried Microsoft® SQL Server™ version information. In addition to version information regarding the actual build number of the server, various environment information is also returned. This information can be used within Transact-SQL statements, batches, stored procedures, and so on, to enhance logic for platform-independent code.
Syntax
xp_msver [optname]
Arguments
optname
Is the name of an option, and can be one of the following.
| Option/Column name | Description |
|---|---|
| ProductName | Product name; for example, Microsoft SQL Server. |
| ProductVersion | Product version; for example, 7.00.419 where 7.00 is the version and 419 is the Microsoft internal build number. |
| Language | The language version of SQL Server. |
| Platform | Operating-system name, manufacturer name, and chip family name for the computer running SQL Server. For example, NT INTEL X86 indicates Microsoft Windows NT® as the operating system, Intel as the chip manufacturer, and a 486 or higher processor. |
| 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. For example, 1998.02.01 indicates a file version of February 1, 1998, on the Sqlservr.exe file. |
| InternalName | Microsoft internal name for SQL Server; for example, SQLSERVR. |
| LegalCopyright | Legal copyright information required for SQL Server; for example, Copyright© Microsoft Corp. 1998. |
| 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 | Microsoft Windows version installed on the computer running SQL Server. For example, 4.0 indicates version 4.0 of Microsoft Windows NT, and 1381 indicates the internal build number. |
| ProcessorCount | The number of processors in the computer running SQL Server. |
| ProcessorActiveMask | Indicates what processors installed in the computer running SQL Server are activated and usable by Microsoft Windows NT. |
| ProcessorType | Processor type. Similar to Platform. |
| PhysicalMemory | Amount in megabytes (MB) of RAM installed on the computer running SQL Server. For example, 32 indicates 32 MB of RAM. |
| Product ID | Product ID (PID) number, which is specified during installation. This number is located on a sticker on the original SQL Server compact disc case. |
Return Code Values
0 (success) or 1 (failure)
Result Sets
xp_msver, without any parameters, returns this four-column result set (values may vary):
Index Name Internal_Value Character_Value ------ ------------------------ -------------- ---------------- 1 ProductName NULL Microsoft SQL Server 2 ProductVersion 458752 7.00.498 3 Language 1033 English (United States) 4 Platform NULL NT INTEL X86 5 Comments NULL NT INTEL X86 6 CompanyName NULL Microsoft Corporation 7 FileDescription NULL SQL Server Windows NT 8 FileVersion NULL 1998.05.25 9 InternalName NULL SQLSERVR 10 LegalCopyright NULL Copyright©Microsoft Corp. 1998 11 LegalTrademarks NULL Microsoft®is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation 12 OriginalFilename NULL SQLSERVR.EXE 13 PrivateBuild NULL NULL 14 SpecialBuild 262242 NULL 15 WindowsVersion 90505220 4.0 (1381) 16 ProcessorCount 1 1 17 ProcessorActiveMask 1 00000001 18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM 19 PhysicalMemory 63 63 (66510848) 20 Product ID NULL NULL (20 row(s) affected)
xp_msver, for any option, returns the four-column headings with values for that option. For example, this result set is returned when xp_msver is executed with the FileDescription option.
xp_msver FileDescription
Index Name Internal_Value Character_Value
------ ------------------------- -------------- ------------------------
7 FileDescription NULL SQL Server Windows NT
(1 row(s) affected)
Permissions
Execute permissions default to the public role.
See Also
System Stored Procedures (General Extended Procedures)