Home Forums SQL Server 7,2000 Administration What is the BEST way to determine the REAL version of SQL 2000?? RE: What is the BEST way to determine the REAL version of SQL 2000??

  • Yeah, I think the big problem for keeping up with the lists is the complexity of the software involved. For example, you have a vulnerability that comes out which is tracked by an MS number. That MS number can lead to multiple KB (or Q for the old numbering system) patches for multiple platforms, such as SQL 2000, 2005, MSDE, and so on. For each of those, depending on the patch type, either GDR or QFE, you can also get a different build number, because it is essentially a different package. I think because of all of this and the fact that major SQL 2000 support stopped in 2008, it is going to be hard to find a "definitive" list of patches. You can ping Microsoft about it though, and they may be able to get you a more detailed one.

    For me though, I just worry about the range of numbers that the build is in. Based on you know that SP 4 started at 2000.8.00.2039. Everything past that should indicate a modification to SQL Server SP4. If you want specifics of what was loaded, you should be able to look up each SQL hotfix applied in Add/Remove Programs, ensuring the checkbox to show updates is shown. Based on the hotfix numbers shown in Add/Remove Programs you should be able to lookup the specific patch and MS vulnerability information for everything loaded since SP4, and it should give you the individual build numbers each one would have left SQL in after the install.

    Joie Andrew
    "Since 1982"