SQL Server 2005 SP2 Bugs

Posted on 2007-10-12
Last Modified: 2010-03-19
I have been told that installing SQL Server  2005 SP2 is not a good idea right now because of all the bugs that come along with SQL Server 2005 SP2. Does anyone have a list of the bugs that occur if you install SQL Server 2005 SP2 on a SQL Cluster or Standalone SQL DB Server? Please advise.
Question by:Omega002
    LVL 5

    Assisted Solution

    I have't heard of any major bugs but there is a cumulative update 3 which I would recommend installing:

    Author Comment

    Ok so are you saying that it is now safe to apply SQL Server SP2? I was told it's buggy and could cause performance issues on your SQL Server databases. Please advise. What was the issue with SQL Server SP2 initially?
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    >it is now safe to apply SQL Server SP2?

    >I was told it's buggy
    maybe a confusion with SP2 of sql 2000, which indeed was not that great...

    Author Comment

    What were the bugs for SQL Server 2005 SP2 when it first came out?
    LVL 5

    Accepted Solution

    I don't believe that there is a definitive list of the bugs contains specifically in SP2
    The fixes that have been created since are a good indication though:

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now