Finding out Editon of the SQL Set up

  • Team,

    Does it is possible to find out edition of the SQL Server setup (2008) without actually installing the instance itself.

  • select @@version

  • Most installation sets contain all editions. The edition that installs depends on the key that you use during set up. Some installations have the key embedded. To see which you have, run the installer, select install new instance and go just a couple steps into the installer til you get to the product key page. If there's a key already embedded, you'll see the edition selected and the selection box greyed out. If there's no edition selected, then the edition installed depends on the product key used.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (10/24/2013)


    Most installation sets contain all editions. The edition that installs depends on the key that you use during set up. Some installations have the key embedded. To see which you have, run the installer, select install new instance and go just a couple steps into the installer til you get to the product key page. If there's a key already embedded, you'll see the edition selected and the selection box greyed out. If there's no edition selected, then the edition installed depends on the product key used.

    Thanks Monster.

  • @aashish : my question was without installation.

    @Gila : Thanks for info.

Viewing 5 posts - 1 through 4 (of 4 total)

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