Monday, October 20, 2014

How to find SQL License type

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

 

image

 

Here is what you see when you run the same query on SQL 2008 R2

 

image

0 comments:

Post a Comment