Returns and allows to be queried 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.
xp_msver [optname]
where
Option name |
Internal version | Example of string description |
|---|---|---|
| ProductName | NULL | Microsoft SQL Server |
| ProductVersion | 393216 | 6.00.105 (6.00 is the version, 105 is the internal build number used by Microsoft) |
| Language | 1033 | U.S. English |
| Platform | NULL | NT INTEL X86 |
| Comments | NULL | NT INTEL X86 |
| CompanyName | NULL | Microsoft Corporation |
| FileDescription | NULL | SQL Server Windows NT |
| FileVersion | NULL | 1995.04.28 |
| InternalName | NULL | SQLSERVR |
| LegalCopyright | NULL | Copyright © Microsoft Corp. 1995 |
| LegalTrademarks | NULL | Microsoft® is a registered trademark of Microsoft Corporation |
| OriginalFilename | NULL | SQLSERVR.EXE |
| PrivateBuild | NULL | NULL |
| SpecialBuild | 0 | NULL |
| WindowsVersion | 65680131 | 3.51 (1002) (3.51 is the Windows NT version, 1002 is the internal build number used by Microsoft) |
| ProcessorCount | 1 | 1 |
| ProcessorActiveMask | 1 | 00000001 |
| ProcessorType | 486 | PROCESSOR_INTEL_486 |
| PhysicalMemory | 32 | 32 (33357821) |
| Product ID | NULL | 12345-1234567890 |
The Product ID (PID) is specified during installation. The number entered is located on a sticker on the original SQL Server CD case.
Execute permission defaults to the public group.