Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
xp_msver (Transact-SQL)

xp_msver (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

xp_msver [ optname ]

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                 

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.

1 (success)

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.

Requires membership in the public role.

Community Additions

ADD
Show:
© 2015 Microsoft