What version of SQL am I currently running?

Here is a quick and simple SQL script to get the current SQL version installed.

 /*==============================================*/
 
 -- Retrieve version of MS SQL Server
 
 Select SERVERPROPERTY('productversion') [Product Version], SERVERPROPERTY ('productlevel') [Product Level], SERVERPROPERTY ('edition') [Edition]
 
 /*==============================================*/

 

I personally use this awesome blog (https://sqlserverbuilds.blogspot.com) to then figure out if I am on the latest build etc..

Hope this helps!

Comments

• Anonymous
  June 08, 2015
  This was very helpful, thank you!