locked
How to check the sql server licenses

    Question

  • select

     

    serverproperty('LicenseType'),serverproperty('NumLicenses') giving result

    DISABLED NULL

    What does it mean?

    I want to check either I can use this sql server in production or how to check the sql server licenses.

     

     


    "SQLSERVER DBA" "INDIA"
    Friday, January 07, 2011 12:30 PM

All replies

  • hi,

    I am sure that if its not a 'developer' edition or a beta version of SQL Server, you can use it in a commerical environment.


    http://sqlservertipsandtricks.blogspot.com/
    Wednesday, April 06, 2011 6:20 PM
  • Hi 

    SERVERPROPERTY('LicenseType') returns the Mode of this instance of SQL Server.

     

    PER_SEAT = Per Seat mode

    PER_PROCESSOR = Per-processor mode

    DISABLED = Licensing is disabled (This will be returned for MSDN or TechNet License or SQL Express or Evaluation or Developer Edition)

    SERVERPROPERTY('NumLicenses') - 

     Number of client licenses registered for this instance of SQL Server if in Per Seat mode.

    Number of processors licensed for this instance of SQL Server if in per-processor mode.

    Returns NULL when the server is none of these.

    MSDN Licenses should be used for Development and Testing and cannot be used for Production, similarly TechNet License should be used for Evaluation purposes

    For detailed reference on SERVERPROPERTY read this article 

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

     

     


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, let us know by clicking "Vote as Helpful" and Propose as Answer
    Thursday, June 09, 2011 3:17 AM