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 (http://sqlserverbuilds.blogspot.com) to then figure out if I am on the latest build etc..

Hope this helps!

Comments (1)

  1. Evan says:

    This was very helpful, thank you!

Skip to main content