<div>
Try:<br />
<br />
SELECT SERVERPROPERTY('LicenseTyp<wbr />e')<br />
<br />
Although often you'll just get back &quot;disabled&quot;, because SQL was loaded from a &quot;master install&quot; copy.
</div>


Try:

SELECT SERVERPROPERTY('LicenseType')

Although often you'll just get back "disabled", because SQL was loaded from a "master install" copy.

<div>
OK so that's not going to help me?
</div>


<div>
this is about what I had to do. &nbsp;It's not the exact answer for according to the information I got you can't determine what the license is after the fact. however, the general rule is if it's more that 90 users then you should go with processor licenses.
</div>


this is about what I had to do.  It's not the exact answer for according to the information I got you can't determine what the license is after the fact. however, the general rule is if it's more that 90 users then you should go with processor licenses.

<div>
You need to try to consolidate as much you can. Specially move from physical servers to virtual. With this you'll save a lot of money only in licensing and also it's a good opportunity to get rid of old servers.
</div>


You need to try to consolidate as much you can. Specially move from physical servers to virtual. With this you'll save a lot of money only in licensing and also it's a good opportunity to get rid of old servers.

<div>
Yep that's what I'm in the process of trying to do. the only thing stopping me is $$$$..
</div>


Yep that's what I'm in the process of trying to do. the only thing stopping me is $$$$..

<div>
&gt;&gt; Those License properties are not used as you can see in this article &lt;&lt;<br />
<br />
Not for SQL 2005 and SQL 2008; they could still be there for versions, depends on how SQL was installed.
</div>


>> Those License properties are not used as you can see in this article <<

Not for SQL 2005 and SQL 2008; they could still be there for versions, depends on how SQL was installed.

<div>
<div class="content wysiwyg-content">
I have a number of servers with SQL some are SQL 2005 and some are SQL 2008. &nbsp;I've been tasked with determining what type of license they have. &nbsp;CALs, &nbsp;or Processors. &nbsp;How do you accomplish this? &nbsp;I'm not a DBA so I'm not sure how to run a query if &nbsp;necessary.
</div>
</div>


I have a number of servers with SQL some are SQL 2005 and some are SQL 2008.  I've been tasked with determining what type of license they have.  CALs,  or Processors.  How do you accomplish this?  I'm not a DBA so I'm not sure how to run a query if  necessary.

Determining how SQL is licensed

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.