Skip to content

seanism DOT com

Random thoughts from the world of seanism

Menu
  • Useful Apps
  • About Me
    • My Resume
  • Contact Me
Menu

How to identify your SQL Server version and edition

Posted on April 6, 2011April 6, 2011 by Sean Young

To find out your version of SQL download/install/open Microsoft SQL Server Management Studio Express then click New Query

Paste the below code in the query pane on the right
SELECT @@VERSION
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
and click Execute

In the results window it will display the version, Service Pack, and edition.

For older versions refer to the command and chart on the Microsoft KB 321185.

Share this:

  • Print
  • Email
  • Facebook
  • Twitter
  • Reddit

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Categories

  • IT
  • Linux
  • Mobile
  • Personal
  • Uncategorized

Tag Cloud!

10.04 activesync backup blog BSOD centOS comic dns eas exchange 2007 iis ios ipad iphone ipod touch itunes linux microsoft moonlight office osx outlook Outlook 2010 pptp printer PST rras sbs server 2003 server 2008 sharepoint silverlight slow sms svn sync TB tortoiseSVN ubuntu visualsvn vpn windows windows 7 windows xp wordpress

Follow me on Twitter

My Tweets

Archives

  • June 2020
  • April 2020
  • July 2016
  • December 2014
  • September 2014
  • April 2014
  • January 2014
  • November 2012
  • April 2012
  • March 2012
  • December 2011
  • November 2011
  • September 2011
  • August 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2022 seanism DOT com | Built using WordPress and Responsive Blogily theme by Superb
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.