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.
xp_msver [ optname ]
Is the name of an option, and can be one of the following values.
|ProductName||Product name; for example, Microsoft SQL Server.|
|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.|
Return Code Values
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.