How to find SQL License type

23 April,2014 by Jack Vamvas

Question: I’m looking for a method to check the license type in Microsoft SQL 2012. Can you show me how to find the SQL Server license type via SQL Server?

 

Answer: Since SQL Server 2012 , you can find this information in the SQL Server Error Logs.

Before SQL Server 2008 R2 there used to be some properties maintained  but is now unused

Mode of this instance of SQL Server.

PER_SEAT = Per Seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled.

 In SQL Server 2012 , a check on the SQL Server error logs will report on information required

 

 

exec xp_readerrorlog 0 ,1 , N'Edition'


Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
	Oct 19 2012 13:38:57 
	Copyright (c) Microsoft Corporation
	Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1  (Build 7601: Service Pack 1) (Hypervisor)


Read More

Powershell and SQL Error Logs

Powershell Scripts for DBA

Powershell List all Patches Updates on a Server

SQL Server – Error Logs recycle without SQL Server Restart


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to find SQL License type


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer