Post reply

SQL Server 200 service packs

  • October 27, 2006 at 5:12 pm

    #668607

    The biggest thing it fixes is the security hole that Slammer worm took advantage of. Without SP3a or higher, your SQL Server is vulnerable to the Slammer worm.

    This is a quote from Microsoft's website for SP3a:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en

    "Download SQL Server 2000 Service Pack 3a (SP3a), the latest and most comprehensive update to SQL Server 2000 that corrects vulnerabilities including the Slammer (W32.slammer) virus."

    -SQLBill

  • October 30, 2006 at 5:30 am

    #668679

    You should get to SP4 and the rollup ( 2187 ) that follows. SP4 has a few problems ( I'm told ) which the rollup fixes. To have a patch level of SP2 is dangerous. I've happily been running on sp4 + rollup for many months with many servers.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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