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.
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
Use this query and execute
you will get output like this
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.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
To get EditionID
If you want to get editionId,which is an integer
select serverproperty('EditionID') EditionID
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
To get productlevel
select SERVERPROPERTY ('productlevel') productlevel
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,
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.
Nice inforamtion posted by you, this was very helpful to those who are don't know about this.
Hope this will helpful to all the people those who are looking for the same.