License Info

• VegaMachine

  SSCrazy

  Points: 2080

  More actions

  April 30, 2004 at 9:40 am

  #84186

  I noticed that on one of our servers when I run the following query to obtain license information I get questionable results.

  The query run is:

  select serverproperty('edition')

  select serverproperty('Licensetype')

  The return is:

  Enterprise Edition

  DISABLED

   

  This instance of SQL Server was installed some time ago and we cannot remember if it is Per Processor or Per Set.  I searched around a bit and could not find any information on why it is returning DISABLED.  Any insight would be helpful.

  Also,

     How does SQL Server react when you install Standard Edition on a 4 processor machine with 4 Gig of ram?  I know that Standard only goes up to 2 Gig of ram and 4 CPUs, but I did find an installation of Standard running on a 4 CPU/4 Gig machine.  Does it simply top out SQL memory usage at 2 Gig without throwing an error, or if we hit the 2 Gig limit will it throw an error?

   Thanks in advance,

  
  
  - Vega

• May 3, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736455

  More actions

  May 3, 2004 at 1:39 pm

  #505038

  I'd suspect it will not let you allocate more than that. Shouldn't throw an error.