Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

SQL server 2008 Build List Expand / Collapse
Author
Message
Posted Friday, January 30, 2009 10:16 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Wednesday, February 11, 2009 11:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 11:13 AM
Points: 65, Visits: 366
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
Posted Wednesday, March 18, 2009 9:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Wednesday, March 18, 2009 9:12 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Wednesday, March 18, 2009 2:50 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 24, 2013 1:07 PM
Points: 2,051, Visits: 75
Are there 64 bit versions of the Cummulative Updates? I can't seen to find them.


Post #678919
Posted Wednesday, April 15, 2009 5:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 7,005, Visits: 8,453
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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #697391
Posted Wednesday, April 22, 2009 3:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 4, 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
Posted Wednesday, April 22, 2009 3:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 4, 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
Posted Wednesday, April 22, 2009 11:04 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
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
Posted Thursday, May 14, 2009 8:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 16, 2014 9:38 AM
Points: 22, Visits: 148
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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse