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)
Hello Andre,
@@version will not give the Service pack information! So use:
SELECT SERVERPROPERTY(‘productversion’) [Product Version],
SERVERPROPERTY (‘productlevel’) [Service Pack],
SERVERPROPERTY (‘edition’) [Edition]
More Info: What is My SQL Server Version, Service Pack, Edition
Thanks,
Sal
Determining What Microsoft SQL Server Edition is Installed (in Spanish):
http://www.sysadmit.com/2015/01/mssql-saber-la-version-de-sql-server-instalada.html