SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL server 2008 Build List


SQL server 2008 Build List

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63426 Visits: 19115
Apologies on the XLS. It's attached now.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brandon Forest
Brandon Forest
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 Visits: 446
Steve,

I am constantly asked to service SQL Servers that others have built. I built the following stored procedure bases on your articles on build versions that I use to evaluate servers. I'm adding it in this forum so that others can use it and update it for the community.

Brandon Forest
SQL Server DBA

/****************************************************************************************************/
USE [master]
GO

/****** Object: StoredProcedure [dbo].[usp_Determine_SQL_Version] Script Date: 02/10/2009 16:07:11 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Determine_SQL_Version]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_Determine_SQL_Version]
GO

USE [master]
GO

/****** Object: StoredProcedure [dbo].[usp_Determine_SQL_Version] Script Date: 02/10/2009 16:07:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


Create Procedure [dbo].[usp_Determine_SQL_Version]

AS

SELECT
SERVERPROPERTY('ServerName') As ServerName,
Case SERVERPROPERTY('productversion')
--SQL Server 6.5
When '6.50.479' Then '6.5 Service Pack 5a (SP5a) Update'
When '6.50.416' Then '6.5 Service Pack 5a (SP5a)'
When '6.50.415' Then '6.5 Service Pack 5 (SP5)'
When '6.50.281' Then '6.5 Service Pack 4 (SP4)'
When '6.50.258' Then '6.5 Service Pack 3 (SP3)'
When '6.50.240' Then '6.5 Service Pack 2 (SP2)'
When '6.50.213' Then '6.5 Service Pack 1 (SP1)'
When '6.50.201' Then '6.5 RTM '

--SQL Server 7.0
When '7.00.1063' Then '7.0 Service Pack 4 (SP4)'
When '7.00.961' Then '7.0 Service Pack 3 (SP3)'
When '7.00.842' Then '7.0 Service Pack 2 (SP2)'
When '7.00.699' Then '7.0 Service Pack 1 (SP1)'
When '7.00.623' Then '7.0 RTM (Release To Manufacturing)'

--SQL Server 2000
When '8.00.194' Then '2000-RTM'
When '8.00.384' Then '2000-SP1'
When '8.00.534' Then '2000-SP2'
--When '8.00.760' Then '2000-SP3'
When '8.00.760' Then '2000-SP3a'
When '8.00.2039' Then '2000-SP4'
When '8.00.2162' Then '2000-SP4-HF1'
When '8.00.2187' Then '2000-SP4-HF2'

--SQL Server 2005
When '9.00.1399.00' Then '2005-RTM'
When '9.00.2047.00' Then '2005-SP1'
When '9.00.3042.00' Then '2005-SP2'
When '9.00.3050.00' Then '2005-SP2-HF1'
When '9.00.3054.00' Then '2005-SP2-HF2'
When '9.00.3186.00' Then '2005-SP2-HF3'
When '9.00.3200.00' Then '2005-SP2-HF4'
When '9.00.3215.00' Then '2005-SP2-HF5'
When '9.00.3228.00' Then '2005-SP2-HF6'
When '9.00.3239.00' Then '2005-SP2-HF7'
When '9.00.3257.00' Then '2005-SP2-HF8'
When '9.00.3259' Then '2005-SP2-HP8a'
When '9.00.3282' Then '2005-SP2-HP9'
When '9.00.4035' Then '2005-SP3'

--SQL Server 2008
When '10.00.1787.00' Then '2008 Hotfix 3 KB:960484'
When '10.00.1779.00' Then '2008 Hotfix 2 KB:958186'
When '10.00.1763.00' Then '2008 Hotfix 1 KB:956717'
When '10.00.1755.00' Then '2008 Bugfix 2 KB:957387'
When '10.00.1750.0' Then '2008 Bugfix 1 KB:956718'
When '10.00.1600.22' Then '2008 RTM (Aug 2008)'
When '10.00.1442.32' Then '2008 RC0 (June 2008)'
When '10.00.1300' Then '2008 CTP (Feb 2008)'
When '10.00.1075' Then '2008 CTP (Nov 2007)'
When '10.00.1049' Then '2008 CTP (July 2007)'
When '10.00.1019' Then '2008 CTP (June 2007)'

--Or Else
Else 'Undetermined'
End As SQLVersion,
SERVERPROPERTY('productversion') As SQLVersionNo,
SERVERPROPERTY ('productlevel') As ServicePack,
SERVERPROPERTY ('edition') As Edition,
@@Version As VerboseVersion
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63426 Visits: 19115
Brandon ,

thanks, and can you add this to the Scripts section as well? That way you can post a link and update that as we add items (or if I remember, I will).

Steve

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63426 Visits: 19115
Apologis, XLS updated.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Dave Lobas
Dave Lobas
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2422 Visits: 94
Are there 64 bit versions of the Cummulative Updates? I can't seen to find them.



ALZDBA
ALZDBA
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12314 Visits: 8928
Can you add SP1 ? support.microsoft.com/kb/968369

BTW. your version numbers are incorrect !

They don't publish like 10.00.***

but the results I get are like 10.0.*** (SP1)

(with both
SELECT SERVERPROPERTY('productversion')
select @@VERSION
)



And off course MS did an effort to document their own Build list ;-)
http://support.microsoft.com/kb/956909/


Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
SmartDBA
SmartDBA
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 19
Here is the link for an excellent article on myTechMantra.com which mentions all the SQL server 2008 and 2005 builds along with the list of respective KB.
SmartDBA
SmartDBA
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 19
Here is the link for an excellent article on myTechMantra.com which mentions all the SQL server 2008 and 2005 builds along with the list of respective KB.
SanjayAttray
SanjayAttray
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4411 Visits: 1619
SmartDBA (4/22/2009)
Here is the link for an excellent article on myTechMantra.com which mentions all the SQL server 2008 and 2005 builds along with the list of respective KB.


The link provided by some one in one of the SQLServerCentral thread is more up to date than the list above.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

SQL DBA.
LSCIV
LSCIV
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 154
Here's the link to the MS site for all builds after SQL 2008 SP1. Don't know why it deserves a separate KB number from the 956909 KB build list, but regardless here it is:

http://support.microsoft.com/kb/970365/

LC
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search