SQL Server version

Question

Post reply

SQL Server version

sql_novice_2007

Hall of Fame

Points: 3307
More actions
October 3, 2013 at 9:32 am

#278630

When I run SELECT @@VERSION on SSMS of the instance I got the following info.
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
I have another instance and when I run the same command I see the following info.
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Does it mean the first one is not an eval version and it'a licensed version?
Is there any other way to confirm if an instance is a licensed version or not?
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

rajborntodare Hall of Fame Points: 3576 More actions · Answer 1

rajborntodare

Hall of Fame

Points: 3576

October 3, 2013 at 11:21 am

#1655642

See this...

http://support.microsoft.com/kb/2793634

Sean Pearce SSCoach Points: 15999 More actions · Answer 2

SELECT

CASE SUBSTRING(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(50)), 1, 4)

WHEN '10.5' THEN '2008 R2'

WHEN '11.0' THEN '2012'

END AS 'SQL Server',

SERVERPROPERTY('ProductLevel') AS 'Level',

SERVERPROPERTY('Edition') AS 'Edition',

SERVERPROPERTY('ProductVersion') AS 'Version';

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 3

I got the following result with the above query.

2012SP1Standard Edition (64-bit)11.0.3000.0

So can we confirm that it's not a evaluation edition?

Thanks.

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

"Enterprise Evaluation Edition" is returned for evaluation.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Jeff Atherton SSCrazy Points: 2663 More actions · Answer 5

What do you get with this:

select

serverproperty('LicenseType') AS LicenseType ,

serverproperty('NumLicenses') AS NumLicenses

Sean Pearce SSCoach Points: 15999 More actions · Answer 6

Jeff Atherton (10/4/2013)
What do you get with this:
select
serverproperty('LicenseType') AS LicenseType ,
serverproperty('NumLicenses') AS NumLicenses

SQL 2005+ no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads the registry for this information, but the SQL 2005 setup doesn’t put licensing information in the registry during setup as in SQL 2000.

This is by-design. Hence, when ServerProperty(‘LicenseType’) is run on a SQL 2005+ installation, ‘DISABLED’ is always returned.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Jeff Atherton SSCrazy Points: 2663 More actions · Answer 7

Sean Pearce (10/4/2013)
SQL 2005+ no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads the registry for this information, but the SQL 2005 setup doesn’t put licensing information in the registry during setup as in SQL 2000.
This is by-design. Hence, when ServerProperty(‘LicenseType’) is run on a SQL 2005+ installation, ‘DISABLED’ is always returned.

Good to know.

LicenseType

Unused. License information is not preserved or maintained by the SQL Server product. Always returns DISABLED.

Base data type: nvarchar(128)

http://msdn.microsoft.com/en-us/library/ms174396.aspx