Post reply

How do I tell if i''ve got sp3 or sp3a

  • September 15, 2005 at 7:24 pm

    #110198

    How do I tell if i've got sp3 or sp3a. They are both .760.?

    Is it worth the bother patching 3 to 3a anyway, or should I go 4.

    thanks

     

  • September 15, 2005 at 10:16 pm

    #590424

    Hi XP,

     

    This may help u select serverproperty('productlevel')

     

    from

    killer

     

  • September 16, 2005 at 2:08 am

    #590452

    nope, it just says sp3

  • September 16, 2005 at 7:30 am

    #590569

    Do select @@version.  Compare the result to the following list

    8.00.194 - Microsoft SQL Server 2000

    8.00.384 - Microsoft SQL Server 2000 SP1

    8.00.532 - Microsoft SQL Server 2000 SP2

    8.00.760 - Microsoft SQL Server 2000 SP3

    8.00.818 - Microsoft SQL Server 2000 SP3 w/ Cumulative Patch MS03-031

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

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