Post reply

Version of SQL 2005

  • November 10, 2011 at 3:26 am

    #262530

    Hi fellow SQL affiliates,

    I would like to update our server to SQL 2005 SP 2 on out Database hotel. Now I have two differe between the below two version?

    Microsoft SQL Server 2005 - 9.00.4060.00 (X64) Mar 17 2011 13:06:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    and

    Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Kind regards

    Lee

  • November 10, 2011 at 3:29 am

    #1405603

    Those are both running SP3 or close to it, so they're well fast the SP2 you want to install. Installing SP4 would be a good idea.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 10, 2011 at 3:38 am

    #1405606

    OK, thanks for the quick reply though one thing is not very clear:

    It says Service pack 2 at the very end, what I am trying to establish is:

    1) Difference btwn what I have underlined 9.00.4060.00 and 9.00.4053.00?

    2) If I was/am running on SP3 why does it stay SP2 at the very end of the @@version query?

    Kind regards

    Lee

  • November 10, 2011 at 4:02 am

    #1405616

    leemunyasia (11/10/2011)

    It says Service pack 2 at the very end, what I am trying to establish is:

    What it says at the end is "Windows NT 5.2 (Build 3790: Service Pack 2)"

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 10, 2011 at 4:03 am

    #1405617

    Lee

    (1) http://www.sqlservercentral.com/articles/Administration/2960/

    (2) That's the Windows version.

    John

  • November 10, 2011 at 5:21 am

    #1405649

    thanks, I now understand that the version related is the winders version.

    I am running on the below:

    Windows Server 2003 standard x64Edition: Version 5.2 build 3790.srv03_sp2_gdr.1010119-0340: Service pack 2)

  • November 10, 2011 at 1:13 pm

    #1405991

    As Gail mentioned, both are already at Service Pack 3, although the 9.00.4060 is a hotfix for a specific issue you must have had.

    Please take a look at the following site, it lists all available versions and updates.

    http://sqlserverbuilds.blogspot.com/

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

Viewing 7 posts - 1 through 6 (of 6 total)

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