Microsoft SQL Server 2005 Service Pack 3 (SP3) contains all the cumulative updates for SQL Server 2005, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported through Windows Error Reporting.
Additionally, the following components have new or improved features.
For a list of the cumulative updates that are included in SQL Server 2005 SP3, see Microsoft Knowledge Base article 955706.
The initial statement on this page, "Microsoft SQL Server 2005 Service Pack 3 (SP3) contains all the cumulative updates for SQL Server 2005" is not entirely correct. That line should read as follows:
SQL Server 2005 SP3 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 2 from cumulative update package 1 to cumulative update package 9.Note: If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or Cumulative Update 11, you must apply a post-SP3 cumulative update after upgrading to SP3 to get all the fixes. This post-SP3 update is available at http://support.microsoft.com/kb/959195/.
This topic will be corrected in the next update of SQL Server 2005 Books Online.
Tai YeeMicrosoft
How do we tell what level of SP2 cumulative updates we are at ?
[Tai Yee - MSFT] Hi -- generally, the best way to get questions answered is to post in the Microsoft Community Forum. The SQL Server Forums are located here: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1 . However, as I happen to know the answer, I will tell you -- please see Knowledge Base article: http://support.microsoft.com/kb/937137/.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')