Post reply

SQL Server SP3 issue

  • September 2, 2009 at 6:40 am

    #133347

    I have SQL Server 2005 SP2. Now i tried to install Sp3 for SQL Server 2005. the installation was successful and since i did not stop any services i did a restart and when i tried to check the service pack by using command "select @@Version" i see the same SP2 there.

    by seeing the server properties i see that SP3 has been installed it shows "SQL Server 9.0.4035".but cannot see when i run the above command. any ideas what wrong? help me please.

  • September 2, 2009 at 7:05 am

    #1048088

    I doubt anything's wrong, the SP2 you're refering to is going to be the OS version, not the SQL Server version.

  • September 2, 2009 at 7:17 am

    #1048098

    So when I run

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    It give the output as

    9.00.4035.00SP3Developer Edition that is good.

    But when I run

    select @@Version

    It give the output as

    Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6002: Service Pack 2)

    So at the end (Build 6002: Service Pack 2) that I see is not for SQL Server right? Its for windows right? So the first command is fine right?

  • September 2, 2009 at 7:26 am

    #1048104

    Yes, the second line is the Windows SP.

  • September 2, 2009 at 7:27 am

    #1048105

    ok thanks a lot. i was confused by that.

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

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