May
13
Written by:
Cindy Gross
Tuesday, May 13, 2008 10:43:06 AM
Finding out which build is the latest or what fixes are included in a particular build can be difficult. These links should make that job easier:
Builds from SQL Server 6.5, 7.0, 2000, 2005, and 2008, includes links to most of the patch downloads:
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Unofficial build chart lists all of the known KB articles, hotfixes and other builds of MS SQL Server 2008, 2005, 2000 and 7.0 that have been released.
http://sqlserverbuilds.blogspot.com/
937137 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
http://support.microsoft.com/default.aspx?scid=kb;EN-US;937137
894905 Cumulative list of the hotfixes that are available for SQL Server 2000 SP4
http://support.microsoft.com/default.aspx?scid=kb;EN-US;894905
To find which build of SQL Server you have there are several options from TSQL:
select @@version
exec xp_msver
select SERVERPROPERTY('Edition') as Edition
, SERVERPROPERTY('ProductVersion') as Version
, SERVERPROPERTY('ProductLevel') as VersionNameWithoutHotfixes
Tags:
Re: Where to find SQL Server hotfixes, service packs, and cumulative updates
The SQL Server development team has announced that they hope to have SQL Server 2005 SP3 available around the end of this calendar year. So you may want to begin considering plans for testing and rolling out SP3 sometime in 2009.
http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx
Also, the SQL Server 2005 SP2 based cumulative updates are now available via self-service, there’s a new link at the top of each that says “View and request hotfix downloads”. Once you click the link and fill out the form, an email will be sent to you with a password that’s good for 7 days to download the fix. We hope to eventually make all SQL Server 2005 hotfix articles available through this self-service feature but the details of that are still being worked out. More details, including screen shots of the process, are detailed in this blog:
http://blogs.msdn.com/psssql/archive/2008/04/25/sql-server-2005-sp3-and-self-service-hotfixes.aspx
Some update related links:
Cumulative update package 8 for SQL Server 2005 Service Pack 2 (3257) http://support.microsoft.com/kb/951217
Cumulative update package 7 for SQL Server 2005 Service Pack 2 (3239) http://support.microsoft.com/kb/949095
Cumulative update package 6 for SQL Server 2005 Service Pack 2 (3228) http://support.microsoft.com/kb/946608
Cumulative update package 5 for SQL Server 2005 Service Pack 2 (3215) http://support.microsoft.com/kb/943656
Cumulative update package 4 for SQL Server 2005 Service Pack 2 (3200) http://support.microsoft.com/kb/941450
Cumulative update package 3 for SQL Server 2005 Service Pack 2 (3186) http://support.microsoft.com/kb/939537
Cumulative update package 2 for SQL Server 2005 Service Pack 2 (3175) http://support.microsoft.com/kb/936305
SP2 http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
Upgrade Advisor latest update http://www.microsoft.com/downloads/details.aspx?familyid=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en
Feature Pack latest update http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
System table map http://www.microsoft.com/downloads/thankyou.aspx?familyId=2ec9e842-40be-4321-9b56-92fd3860fb32&displayLang=en&oRef=
BOL http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
BOL latest update http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
Samples/Sample DBs latest update http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&mg_id=10053&displaylang=en
By cindygross on
Monday, June 23, 2008 4:08:48 PM
|