How to determine if you are running SQL Express or SQL Standard
Procedure Steps
In SQL Server Management Studio, run the following query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')The query returns the SQL Server version, product level, and edition.
Applies To
SQL Server (All versions)
