About Version and edition of SQL Server

Most of the people are confused with the version of the SQLSever.
They are frequently using SQL queries , stored procedure etc.But unaware of some basic things regarding its version, product etc. I am trying to give you some queries regarding server with this article.


If you set a dedicated server from any other hosting services, you have to check whether the configuration we decided will match with the server.

To check the Version of the server

(Build 7601: Service Pack 1)

This is the configuration of my system's SQLServer version

Here you can understand This is SQL Server 2008 R2 version
RTM- Release To Manufacturing
It is Develop edition,32 bit
Service pack 1 means service pack of the operating system, not the service pack of the SQL Server.

To get the edition

select serverproperty('Edition') Edition

Output

Developer Edition

To get EditionID

If you want to get editionId,which is an integer
select serverproperty('EditionID') EditionID

output

-2117995310

These are the list of different outputs

-2117995310 = Developer
-1253826760 = Desktop
-1592396055 = Express
-1534726760 = Standard
1333529388 = Workgroup
1804890536 = Enterprise
-323382091 = Personal
610778273 = Enterprise Evaluation
1044790755 = Windows Embedded SQL
4161255391 = Express with Advanced Services

To get productversion

SELECT SERVERPROPERTY('productversion')productversion

Output

10.50.1600.1

To get productlevel

select SERVERPROPERTY ('productlevel') productlevel

output

RTM

To identify the virtual processors in SQLServer

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio ASHyperthread_Ratio,
cpu_count/hyperthread_ratio AS Physical_CPU_Count,
physical_memory_in_bytes/1048576 AS Physical_Memory_in_MB,
sqlserver_start_time, affinity_type_desc
FROM sys.dm_os_sys_info

Output

2 2 1 3063 2013-12-08 18:50:30.430 AUTO

Also you will get the details in the menu.Start Management studio, click About in Help menu.

Attachments