Post reply

SQL Server 2005 Developer Edition and service packs

  • June 6, 2007 at 1:39 pm

    #176978

    Hello,

    I just installed SQL Server 2005 Developer Edition and ran select @@version and got the following:

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    It says Service Pack 2 but the release date is so old. Do I need to install the post-March 2007 Service Pack 2?

    I checked Steve's build list below but did not see this build on the list.

    http://www.sqlservercentral.com/columnists/sjones/2960.asp

    Thanks for any help!

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • June 6, 2007 at 3:06 pm

    #711251

    That version of SQL Server 2005 does not have SP 2 installed.  In the @@version, the service pack 2 mentioned, I believe, is for the OS you are running on.  SP 2 of SQL Server 2005 should take the version number to 9.0.2042.?.

  • June 6, 2007 at 3:07 pm

    #711252

    Ah, yes, that makes sense.

    Thanks for pointing that out. 🙂

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing 3 posts - 1 through 2 (of 2 total)

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