Chau @@Version, hola xp_msver

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.