SQL Server Product,Version,Edition and Other Information in SQL

SQL Server Product,Version,Edition and Other Information in SQL

Query to Check SQL Server Version Edition ,Product and Other Info Related SQL.

--Version Info

SELECT @@version SQLversioninfo

Output--My SQLServer Info 

SQLversioninfo

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)   Jun 11 2012 16:41:53   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) 

--ProductVersion,Productlevel and Edition

SELECT SERVERPROPERTY('productversion') as Productversion , SERVERPROPERTY ('productlevel') Productlevel , SERVERPROPERTY ('edition') edition

Output-My SQLServer Info

Productversion   Productlevel    edition

10.50.2550.0 SP1 Enterprise Edition (64-bit)

--Product,Version,Platform and Other Info

exec xp_msver

Output-My SQLServer Info

Index Name Internal_Value Character_Value

1 ProductName NULL Microsoft SQL Server

2 ProductVersion 655410 10.50.2550.0

3 Language 1033 English (United States)

4 Platform NULL NT x64

5 Comments NULL SQL

6 CompanyName NULL Microsoft Corporation

7 FileDescription NULL SQL Server Windows NT - 64 Bit

8 FileVersion NULL 2009.0100.2550.00 ((KJ_SP1_GDR).120611-1632 )

9 InternalName NULL SQLSERVR

10 LegalCopyright NULL Microsoft Corp. All rights reserved.

11 LegalTrademarks NULL Microsoft SQL Server is a registered trademark of Microsoft Corporation.

12 OriginalFilename NULL SQLSERVR.EXE

13 PrivateBuild NULL NULL

14 SpecialBuild 167116800 NULL

15 WindowsVersion 498139398 6.1 (7601)

16 ProcessorCount 4 4

17 ProcessorActiveMask NULL               f

18 ProcessorType 8664 NULL

19 PhysicalMemory 8000 8000 (8388141056)

20 Product ID NULL NULL