Cumulative Updates and Service Pack versions for SQL 2008

By tom on September 24th, 2009

To find out exactly which edition, Cumulative Update and Service Pack version you are running, you can execute following query in a query window:

select SERVERPROPERTY(‘productversion’), SERVERPROPERTY(‘productlevel’), SERVERPROPERTY(‘edition’)

This will return something like this:

10.0.2531.0 SP1 Enterprise Edition (64-bit)

 

(An overview of all SERVERPROPERTY properties can be found here)

 

In the following table, I give an overview of the current version numbers, with their mapping to the correct Cumulative Update and Service Pack version:

 

Version Service Pack (SP) / Cumulative Update (CU)
10.0.2734.0 SP1 CU4
10.0.2723.0 SP1 CU3
10.0.2714.0 SP1 CU2
10.0.2710.0 SP1 CU1
10.0.2531.0 SP1
10.0.1818.0 CU7
10.0.1812.0 CU6
10.0.1806.0 CU5
10.0.1798.0 CU4
10.0.1787.0 CU3
10.0.1779.0 CU2
10.0.1763.0 CU1
10.0.1600.0 SQL 2008 RTM

 

I will try to keep this overview up-to-date when more Cumulative Updates and Service Packs appear.

 

Tom

New/Updated features in Quest LiteSpeed 5.1.1

By tom on September 24th, 2009

In my previous post, I told you about Quest LiteSpeed as a backup tool for your SQL environment. In the meantime they have a minor updated build, where now they have added support for the SQL Server 2008 FILESTREAM type (previous version gave an unclear error). It also includes some fixes for known issues.

You can find the release notes here.