Export (0) Print
Expand All
28 out of 46 rated this helpful - Rate this topic

How to: Identify a SQL Server Express Instance

SQL Server 2005

You can use the sqlcmd utility to determine which edition of SQL Server is used for a currently-running instance. Microsoft SQL Server 2005 Express Edition (SQL Server Express) instances display "Express Edition."

  1. Connect to an instance of SQL Server by using the following sqlcmd command:

    sqlcmd -S Server\Instance

    Where Server is the name of the computer and Instance is the name of the instance you want to check. If you have used the default named instance during setup, specify the instance as "SQLExpress".

  2. To identify the server name and instance name, type the following command:

    select @@servername
    go
    
  3. When connected, type the following two commands:

    select @@version
    go
    
  4. Alternatively, you can type the following two commands:

    select serverproperty('edition')
    go
    

    The sqlcmd tool displays the version information. If the last line of information includes "Express Edition," the instance to which you are connecting is running SQL Server Express.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.