Post reply

SQL 2005 SP2 Fixed Version

  • June 11, 2008 at 3:23 am

    #154436

    All,

    Could you please verify the correct @@version of the "Fixed" SQL Server 2005 SP2?

    I have downloaded and installed SP2 from MS website onto a new server and it the version is 3042.

    Regards

    Carl

  • June 11, 2008 at 12:53 pm

    #827476

    It should be Version: 9.00.3042 as specified under Quick details section on

    http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

    Manu

  • June 11, 2008 at 1:18 pm

    #827483

    In case you want to keep track of what's going on:

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


    * Noel

  • June 12, 2008 at 1:59 am

    #827685

    Thanks for the replies.

    Regards

    Carl

  • June 13, 2008 at 9:27 am

    #828618

    The "corrected" SP2 can also be labeled 3050 or 3054 depending upon what version was installed and then patched.

    I installed the original SP2 and then applied the fix issued immediately afterwards, and I get 3054. As in:

    Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

    Mar 23 2007 16:28:52

    Copyright (c) 1988-2005 Microsoft Corporation.

    There was a lot of confusion immediately post SP2 rollout. KB article 933508 (http://support.microsoft.com/kb/933508) was changing almost on a weekly basis.

    Even the current document states that 3042 is the wrong version for the Maintenance Plan Tasks DLL.

    Unfortunately, Microsoft kept the same version (3042) for both the "bad" and the "good" SP2. It all depends upon when you downloaded SP2. If you obtained SP2 recently, you should be OK.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply