Post reply

Determining Standard or Enterprise Installed

  • July 10, 2001 at 10:57 am

    #77688

    We are running SQL 7.0 SP1. How do I determine which version is installed, i.e. Standard vs. Enterprise?

    And if Standard, can this be upgraded to Enterprise with the SQL 2000 installation?

    Thanks

    Jay

  • July 10, 2001 at 11:01 am

    #416987

    If you run select @@version it will tell you what version you're on. For example, here's the results from a development server:

    Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)

    Mar 2 2000 06:49:37

    Copyright (c) 1988-1998 Microsoft Corporation

    Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1, RC 1.1)

    Brian Knight

    bknight@sqlservercentral.com

    Brian Knight
    Free SQL Server Training Webinars

  • July 10, 2001 at 11:08 am

    #416993

    I missed the second part of your question...sorry! You can do the upgrade to 2000. Just make sure you backup all the databases before the upgrade.

    Brian Knight

    bknight@sqlservercentral.com

    Brian Knight
    Free SQL Server Training Webinars

  • July 10, 2001 at 11:36 am

    #416998

    select @@version

    This will tell you what version you are running with what service pack and what OS. like this

    =========================

    Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)

    Mar 2 2000 06:49:37

    Copyright (c) 1988-1998 Microsoft Corporation

    Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

    ============================

    Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA

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

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