SQL Versions – Tip of the day

I was installing SharePoint 2010 – wait, what about the pre-requisites?
- SQL 2005 SP3 with Cumulative update package 3
- OR SQL 2008 SP1 with Cumulative update package 2

So what version have we got? Here’s the tip of the day (for me and to you to share), run this SQL Query to find out:

SELECT serverproperty('productversion'),
       serverproperty('productlevel'),
       serverproperty('edition') 

This should give you information to determine the version number, the release level (RTM or Service Pack), and the edition (Express, Standard or Enterprise).

For convenience, I’ve added the version numbers required for SharePoint 2010:
- SQL 2005 SP3  - 2005.90.4035
- SQL 2008 SP1 – 2007.100.2531.0


For more version numbers go to http://support.microsoft.com/kb/321185.

Referenced from this Microsoft KB http://support.microsoft.com/kb/321185