Solved

SQL  server licensing information

Posted on 2014-12-10
1
69 Views
Last Modified: 2014-12-11
Hi Experts,

I recently join an  organisation and I need to check if the sql servers are licensed or not( I have no experience in SQL licensing at all, all I know is they are supposed to be Core base licenses )  . any idea why  I get disabled  when I run “  SELECT SERVERPROPERTY('License Type')

I have SQL 2008 r2 and 2012 in the environment.

Thanks
0
Comment
Question by:shahin37
1 Comment
 
LVL 29

Accepted Solution

by:
Rich Weissler earned 500 total points
Comment Utility
I believe from SQL 2005 and on, the license information isn't tracked inside the application any longer.  It's more of an honor system, and you are expected to keep track of the licenses and have paper licenses available for your systems.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now