Extracting SQL Server Information

• dgbrown

  Say Hey Kid

  Points: 710

  More actions

  May 17, 2005 at 3:50 pm

  #102533

  Greetings all,

  Does anyone know how to programmatically (via T-SQL, DMO, etc) extract SQL Server licensing information (is it running under a Processor or Per Seat License)? I'd like to compile a bunch of info about SQL Server such as Version (7.0, 2000), Server SKU (Enterprise or Standard), Licensing (Processor or Per Seat) and the number of CPU's. I've got everything down except for the Licensing part. I know that if you go to the Control Panel and open up the SS Licensing Setup you can get that information but I need to access it programmatically.

  Any help would be much appreciated.

  Thanks,

  DB

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  May 17, 2005 at 4:33 pm

  #559430

  The license information is in the registry, here is a .reg for a 2 CPU license:

  [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo\MSSQL8.00]

  "FlipAllow"=dword:00000000

  "ConcurrentLimit"=dword:00000002

  "DisplayName"="SQL Server 2000"

  "FamilyDisplayName"="Microsoft SQL Server"

  "Mode"=dword:00000002

  SQL = Scarcely Qualifies as a Language

• philcart

  SSC-Forever

  Points: 47794

  More actions

  May 17, 2005 at 4:36 pm

  #559431

  You could also take a look at the SERVERPROPERTY function in Books Online

   

  --------------------
  Colt 45 - the original point and click interface

• dgbrown

  Say Hey Kid

  Points: 710

  More actions

  May 18, 2005 at 9:31 am

  #559626

  Thanks for the help Phill and Carl. I'm able to get all the information that I need now.

  Darias