How to find out which version and edition of Microsoft SQL Server you are running

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)

Advertisements

2 Responses to “How to find out which version and edition of Microsoft SQL Server you are running”


  1. 1 Salaudeen October 2, 2012 at 5:52 am

    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

  2. 2 DumasLein January 9, 2015 at 2:14 pm

    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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




RSS Information Week Headlines

  • An error has occurred; the feed is probably down. Try again later.

RSS SharePoint Team Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS InfoPath Team Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS Joel Oleson Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS Susan Hanley’s KM Blog

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 350,836 hits

%d bloggers like this: