End of Service Pack Support for SQL Server 2005 SP2 and SQL Server 2008 RTM

End of Service Pack Support for SQL Server 2005 SP2 and SQL Server 2008 RTM

Rate This
  • Comments 6

We would like to remind all customers that Service Pack Support for SQL Server 2005 Service Pack 2 (SP2)  will end on January 12, 2010 and support for SQL Server 2008 RTM will end on April 13, 2010.  Microsoft is ending support for these products as part of our Service Pack support policy, found in http://support.microsoft.com/lifecycle

 

Both SQL Server 2005 SP2 and SQL Server 2008 RTM will no longer receive assisted support or security updates from Microsoft after their respective end of support dates.  Self-Help online support will continue to be available for a minimum of 12 months after the product reaches the end of support.  Self-Help options include public knowledge base articles, FAQs, troubleshooting tools which are typically available from http://support.microsoft.com and the Microsoft Download Center.

 

Customers are encouraged to prepare and execute on their upgrade and/or sustained engineering plans as early as possible for these SQL versions.  Remaining current on your service pack installation ensures that your products remain supported per the Support Lifecycle policy.  Additionally, your software benefits from the many enhancements, fixes, and security updates provided through the latest service pack.

 

For Premier Support customers who anticipate they will not be able to complete their migration for these products by the transition date and need additional support from Microsoft, Custom Support is also available for purchase.  Please contact your Technical Account Manager, Account Representative or Application Development consultant for details.

 

Below is a more detailed table listing versions in or close to end of the support cycle, together with possible options / actions.

 

Product

Version

SP

Mainstream Support End Date

Extended Support End Date

Options / Notes

SQL Server

2000

SP4

04/08/2008

04/09/2013

Technical support continues till 04/09/2013, yet mainstream (hotfix) support ends as of 04/08/2008; options for hotfix support after 04/08/2008:

ð  Upgrade to SQL Server 2005 SP3 or SQL Server 2008 SP1

ð  Extended support agreement

SQL Server

2005

RTM (SP0)

07/10/2007

07/10/2007

Technical support ends as of 07/10/2007; options for technical and/or hotfix support after this date:

ð  Continue with self-help

ð  Upgrade to SQL Server 2005 SP3 or SQL Server 2008 SP1

SQL Server

2005

SP1

04/08/2008

Not Applicable

Technical support ends as of 04/08/2008; options for technical and/or hotfix support after this date:

ð  Continue with self-help

ð  Upgrade to SQL Server 2005 SP3 or SQL Server 2008 SP1

SQL Server

2005

SP2

01/12/2010

Not Applicable

Technical support ends as of 01/12/2010; options for technical and/or hotfix support after this date:

ð  Continue with self-help

ð  Upgrade to SQL Server 2005 SP3 or SQL Server 2008 SP1

ð  Custom support agreement

SQL Server

2005

SP3

See Options/Notes

Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. Visit the Lifecycle page to find the support timelines for your particular product.

SQL Server

2008

RTM

(SP0)

04/13/2010

Not Applicable

Technical support ends as of 04/13/2010; options for technical and/or hotfix support after this date:

ð  Continue with self-help

ð  Upgrade to SQL Server 2008 SP1

ð  Custom support agreement

SQL Server

2008

SP1

See Options/Notes

Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. Visit the Lifecycle page to find the support timelines for your particular product.

 

Thank you,

Christina Gendrano

Program Manager

SQL Server Sustained Engineering

Leave a Comment
  • Please add 4 and 2 and type the answer here:
  • Post
  • How and where do I get SP 3 to update my computer?

  • Hi Kathy - I am assuming you are looking for where to get SQL Server 2005 SP3.  You can find the information in support.microsoft.com/.../913089.

    Thanks!

  • There is SP4 also release for SQL Server 2005. Can I get the information for SQL Server 2005 like I have for SQL Server 2000.

    Can I get the information on it and Hotfix which is stable like for SQL Server 2000 most stable was (SP4 with Hot Fix and AWE feature: 8.00.2187)

    Details about SQL Server 2000

    Service Pack Service Pack code

    Without Service pack 8.00.194

    SP3 8.00.760

    SP4 8.00.2039

    SP4 with Hot Fix 8.00.2040

    SP4 with Hot Fix and AWE feature 8.00.2187

  • Aman - popular sites that post SQL versions include:

    www.sqlteam.com/.../sql-server-versions

    sqlserverbuilds.blogspot.com

    sqlsecurity.com/.../Default.aspx

  • SQL Server 2005 mainstream support phase ends on April/2011.

    After that, Can I consider SQL Server 2005 as a back level version?

  • hi, i am having trouble with my sql procedure, i want to select a couple of records from a view and populate them into a table by first deleting all content of that table, and then selecting all the table records.

    here are my code listing, any one got idea how to go by it?

    USE [db_bamigration]

    GO

    ALTER PROCEDURE [dbo].[GetExcel]--(@PIN VARCHAR(50))

    -- Add the parameters for the stored procedure here

    -- @PIN VARCHAR(50)

    AS

    DELETE FROM GetExcelDataMain

    go

    INSERT INTO GetExcelDataMain

         ([PIN]

         ,[FNAME]

         ,[MNAME]

         ,[LNAME]

         ,[EMPLOYER]

         ,[ADDRESS]

         ,[SOP]

         ,[DOFC]

         ,[CUM_NET_CONT]

         ,[CUM_WITHDRAWAL]

         ,[NET_CONT]

         ,[CUM_GAIN]

         ,[CURRENT_VAL]

         ,[CUM_UNIT_PURCHASED]

         ,[UNIT_PRICE]

         ,[STMTPERIOD]

         ,[ROWID]

         ,[EFFECTIVEDATE]

         ,[MONTH]

         ,[DESCID]

         ,[AMOUNT]

         ,[MANDATORY]

         ,[LEGACY]

         ,[VOLUNTARY]

         ,[UNITPURCHASED]

         ,[UNITPRICE]

         ,[NETCONT]

         ,[MONTHID]

         ,[PrnOrder]

         ,[UserID]

         ,[period]

         ,[year])

    SELECT [PIN]

         ,[FNAME]

         ,[MNAME]

         ,[LNAME]

         ,[EMPLOYER]

         ,[ADDRESS]

         ,[SOP]

         ,[DOFC]

         ,[CUM_NET_CONT]

         ,[CUM_WITHDRAWAL]

         ,[NET_CONT]

         ,[CUM_GAIN]

         ,[CURRENT_VAL]

         ,[CUM_UNIT_PURCHASED]

         ,[UNIT_PRICE]

         ,[STMTPERIOD]

         ,[ROWID]

         ,[EFFECTIVEDATE]

         ,[MONTH]

         ,[DESCID]

         ,[AMOUNT]

         ,[MANDATORY]

         ,[LEGACY]

         ,[VOLUNTARY]

         ,[UNITPURCHASED]

         ,[UNITPRICE]

         ,[NETCONT]

         ,[MONTHID]

         ,[PrnOrder]

         ,[UserID],substring(month,1,3) as period, substring(month,5,4) as [year]

    FROM [db_bamigration].[dbo].[GetExcelData]

       Where PIN='PEN100125546717'

       Order By [year],MonthID,DESCID

    GO

    Select * from dbo.GetExcelDataMain

    GO

Page 1 of 1 (6 items)