Post reply

Edition

  • May 12, 2004 at 6:23 am

    #84411

    Hi All,

    How do I find the edition of SQL Server7.0 installed

    Levi


    Jesus My Saviour

  • May 12, 2004 at 6:45 am

    #506122

    select @@version

  • May 12, 2004 at 11:08 pm

    #506230

    In version 8 you can also use ServerProperty, I think it was also available in v7

    select Serverproperty('Edition')

    This will provide output eg: Desktop Engine

    The ‘Edition’ serverproperty will return one of the following values

      • Desktop Engine
      • Developer Edition
      • Enterprise Edition
      • Enterprise Evaluation Edition
      • Personal Edition
      • Standard Edition

      There are other Serverproperty types eg ProductVersion, ProductLevel and InstanceName... see BOL

    Viewing 3 posts - 1 through 2 (of 2 total)

    You must be logged in to reply to this topic. Login to reply