Post reply

Upgradation fails of sql server2k sp1 to sp4

  • February 16, 2009 at 2:27 am

    #126475

    Hi,

    I am applying sp4 for sql server2k with all steps i have followed with installing sp4,the setup successfully completes then to it is showing the following msg

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    when i querry with select @@version on querry analyser....

    and i dodnt want to upgrade it with sql server2005.......my application is dependent on sql server2k

    what will be the better solution ......

    Thanks,

    Sameer

  • February 16, 2009 at 5:05 am

    #944426

    If I understood your questions properly, it is still on SQL 2000. The one which you are talking about is the release date by MS

  • February 16, 2009 at 5:23 am

    #944429

    Hi,

    select @@version shows the os level where you are checking for service pack. You can check the current service pack for sql server using the following command

    select serverproperty('ProductLevel')

    Thanks

    Chandra Mohan N

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • February 16, 2009 at 5:33 am

    #944433

    Hey,

    Hi chandra mohan solved with the issue......

    Thanks,

    sameer

  • February 16, 2009 at 5:38 am

    #944437

    Can you tell me whether my post helped you ?

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

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

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