SQL server 2008 Build List

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » SQL server 2008 Build List

74 posts, Page 2 of 8

««1 2 3 4 5 »»»

SQL server 2008 Build List

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Friday, January 30, 2009 10:16 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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

Post #647145

Brandon Forest

Posted Wednesday, February 11, 2009 11:04 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 11:29 AM
Points: 60, Visits: 303

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

Post #655112

Steve Jones - SSC Editor

Posted Wednesday, March 18, 2009 9:09 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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

Post #678595

Steve Jones - SSC Editor

Posted Wednesday, March 18, 2009 9:12 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Apologis, XLS updated.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #678603

Dave Lobas

Posted Wednesday, March 18, 2009 2:50 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, February 15, 2013 10:49 AM
Points: 1,874, Visits: 73

Are there 64 bit versions of the Cummulative Updates? I can't seen to find them.

Post #678919

ALZDBA

Posted Wednesday, April 15, 2009 5:14 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861, Visits: 8,045

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

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't 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" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #697391

SmartDBA

Posted Wednesday, April 22, 2009 3:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 04, 2009 4:42 AM
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.

Post #702151

SmartDBA

Posted Wednesday, April 22, 2009 3:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 04, 2009 4:42 AM
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.

Post #702153

SanjayAttray

Posted Wednesday, April 22, 2009 11:04 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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.

Post #702548

LSCIV

Posted Thursday, May 14, 2009 8:58 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 23, 2012 8:20 AM
Points: 21, Visits: 135

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

Post #717045

« Prev Topic | Next Topic »

74 posts, Page 2 of 8

««1 2 3 4 5 »»»

Permissions