Post reply

How to distinguish SQL Server Express from SQL Server standard/enterprise

  • June 9, 2009 at 3:41 pm

    #95416

    Hello, all.

    Using C# and connecting via ADO or other method to a SQL Server database, is there any way to tell whether the instance is or isn't a SQL Server Express instance - versus standard/enterprise SQL Server? Our app will not know the data source prior to startup, and there are certain functions that should only execute when the instance is SQL Server Express. Thanks in advance!

  • June 9, 2009 at 3:50 pm

    #1007102

    SELECT SERVERPROPERTY ('EngineEdition') Will return one of 'Standard','Enterprise','Express'.

    Developer, Enterprise and Enterprise evaluation all return 'Enterprise'. Standard and Workgroup return 'Standard' and Express, Express with Advanced Services, and Windows Embedded SQL all return 'Express'

    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

  • June 9, 2009 at 4:08 pm

    #1007108

    Fantastic! Thanks, Gail.

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

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