SQL Server 2000 latest sp and hotfix issues

Posted on 2008-11-10
Last Modified: 2012-05-05
A security scan reported my sql 2000 server did not have the latest sp and hot fix applied.  It showed vulnerability details:  Database version=8.00.2039, Latest Hotfix=8.00.2271.  I applied sp 4 per;  and looked at the audit reference  I had a post audit scan run and it still tells me I have vulnerablitity details Database Version=8.00.818, Patched Version=8.00.2271.  

I've looked at the MS site and am confused as to what I need to apply to get to the latest hotfixes.  All the numbers show less than the version I show.  I would appreciate help in checking what versions I have and understanding what I need to apply to be at the latest patches.

Question by:okcuser

    Author Comment

    When I run on the server:
    SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
    I get:
    8.00.2187, SP4, Standard Edition
    LVL 11

    Expert Comment

    by:N R
    I believe the newest version is 8.00.384

    Accepted Solution

    so where do I find it?  According to the documentation I was sent with the audit, the latest service pack for SQL Sever 2000 is sp4 _ Q946584 Hotfix (version 8.00.2271).  But when I look on the MS website, I can't find where you can download that hotfix.
    LVL 11

    Expert Comment

    by:N R
    Yep I just found that, you have to request it.  Otherwise you are the most current.  Are all the clients current that are connecting to the server?

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now