liscence information

Does SQL itself store any information about what type of liscence has been applied to the installation (be it CAL or Core based)? Is there a query that could be used to determine what kind of liscence is being used on that specific SQL server?
LVL 3
pma111Asked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
That query above is no longer working since 2008 as they are both "Unused" - see link below.

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

I'm afraid there is no way to get the licensing info from the SQL Server and your only way to find it is to call Microsoft if that info was lost and nobody at your place has any details related to licensing for that SQL Server.
0
 
Vijaya Reddy Pinnapa ReddyConnect With a Mentor Commented:
Please run this query

SELECT SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses')
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
I agree, sql server wont store the License info, you need to check the old emails ofr the invoices related to the SQL Server
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.