Re: SQL Serverlicense compliance

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joseph Calabig [MSFT] (jcalabig_at_microsoft.com)
Date: 01/12/05 

Date: Tue, 11 Jan 2005 16:37:27 -0800

Have you tried doing a "select serverproperty ('propertyname')" in SQL?
That should return what you want. You can then just script this to a NOIDMIF
or extend WMI and get this over to Hardware Inventory.
Hope this helps. 

-- 
Thanks,
Joseph Calabig
This posting is provided "AS IS" with no warranties, and confers no rights.
"Henrik (DK)" <HenrikDK@discussions.microsoft.com> wrote in message 
news:0F8DA81F-E0D2-4DE0-8847-B2F7FCB30035@microsoft.com...
> Hi!
>
> Anyone figured out how to scan for and check which license model your SQL
> servers is using.
>
> You know, they could be standalone,clustered,Active-Passiv,Active-Active
> and the hardware can be hyperthreaded which can influence ow many 
> processors
> are reported.
>
> Henrik

Relevant Pages

  • Re: Software Inventory - Microsoft License True Up - SQL Version and P
    ... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY, ... the Microsoft True Up, in particular reference to MS SQL. ... Has anybody had success in determining inventory information for MS SQL ...
    (microsoft.public.sms.admin)
  • Re: Management Point Problem.
    ... - or you MP and SQL cannot communicate with each other. ... Possible cause: Out of disk space. ... > MP cannot load the hardware inventory class mapping table when processing ... MP cannot communicate with the SQL data base. ...
    (microsoft.public.sms.misc)
  • Re: SQL Table indexes
    ... Henrik, ... SQL Server Books Online is the best source of information for this ... Why we creat index and how to creat ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Changing server collation
    ... The serverproperty shows the collation as ... Sql_ Latin1_General. ... What does the SERVERPROPERTY() function say? ... When I look at rebuildM now, it shows Dictionary Order, Case ...
    (microsoft.public.sqlserver.server)
  • Re: SQL License
    ... Check out SERVERPROPERTY() in BOL. ... Andrew J. Kelly SQL MVP ... > Is there a Query to find the licesnse scheme that SQl is using? ... procesor or per seat and does it give a quantity? ...
    (microsoft.public.sqlserver.programming)