How to check the sql server licenses


  • select


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


    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.



    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.

    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 




    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