Finding SQL Licensing information?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sandeepkavade
    New Member
    • Mar 2007
    • 30

    Finding SQL Licensing information?

    hi all,
    I want to retrive the licensing information such as Licensing count, which
    licensing is currently in use, whats its type (per processer or per user),
    licensing code etc. From where i can retrive the information? I want to do it
    for Sql Server 2005 and 2000. I read the blog "Tracking License Information
    in SQL 2005" on
    http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
    but it doesnt help me at all.
  • deepuv04
    Recognized Expert New Member
    • Nov 2007
    • 227

    #2
    Originally posted by sandeepkavade
    hi all,
    I want to retrive the licensing information such as Licensing count, which
    licensing is currently in use, whats its type (per processer or per user),
    licensing code etc. From where i can retrive the information? I want to do it
    for Sql Server 2005 and 2000. I read the blog "Tracking License Information
    in SQL 2005" on
    http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
    but it doesnt help me at all.
    SELECT SERVERPROPERTY( 'LicenseType')

    LicenseType - Mode of this instance of SQL Server.
    PER_SEAT = Per-seat mode
    PER_PROCESSOR = Per-processor mode
    DISABLED = Licensing is disabled.

    SELECT SERVERPROPERTY( 'NumLicenses')

    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 if the server is none of the above.

    Comment

    Working...