Post reply

Standard or Enterpise Edition of SQL Server

  • February 24, 2009 at 11:40 am

    #126660

    I run this but it does not give me info on Standard or Ent. Edition of SQL Server. It states Standard or Ent of WIndows but not SQL Server.

    SELECT @@ServerName AS Server,

    LEFT(@@version, 26) AS Version

    SELECT @@VERSION

    SELECT

    SERVERPROPERTY('productversion'),

    SERVERPROPERTY('productlevel')

  • February 24, 2009 at 11:43 am

    #949560

    This will give you the version and service pack level

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Thanks,

    Lori

  • February 24, 2009 at 11:47 am

    #949563

    That is it, I was missing the one part. THanks !

  • February 25, 2009 at 5:48 am

    #949902

    A much more easier query to remember is ...

    select @@version

    ... everything you are looking for is there. 😎

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • February 25, 2009 at 8:11 am

    #950001

    You're right - select @@version does give you everything. Mine is just more focused and helps with my lack of attention span 😉

    Thanks,

    Lori

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

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