This question comes up often: How do I find out which version and edition of Microsoft SQL Server I am running? Is it Enterprise, Standard, or Developer?
It’s actually quite simple to get the answer:
1. Open SQL Server Management Studio (SSMS).
2. Click on the “New Query” button to open a new query window.
3. Enter the following query and click on “Execute”:
PRINT @@VERSION
You should see a query result similar to the following:
Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)