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.
.gif)
Transact-SQL Syntax Conventions
Syntax
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
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