This shows the license type and number of licenses:

The following example uses the function SERVERPROPERTY in a SELECT statement to return information about the server. This situation is useful when there are multiple instances of SQL Server installed on a Win server, and the customer must open another connection to the same instance used for the current connection.

sqlserverproperty
or

Or more detail:

SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name.

sqlserverproperty2

How do I find out what License has been applied to my SQL Server installation?
5 (100%) 3 vote[s]