I have the developer edition of MS SQL and applied SP4 to it. Here's what I get when I execute SELECT @.@.Version:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
According to the readme, here are the version numbers for each service pack:
Do I trust the Version Number or the Product Level? Anyone know what the story is? TIA.
The numbers are TDS( tabular data stream) yes the increament is based on service packs in SQL Sever 2000 and in Win2k you are missing two service packs because I have a box in Houston running it and as of 2005 December I had SP4, I have installed the product that is SQL Server 2000 on all existing os including XP home. I also have SQL Server 2000 SP3 and SP3a in .sql files. So you just need two service packs for Win2k. Hope this helps.|||Thanks Caddre. I didn't realize it was reporting the OS service pack as opposed to the SQL Server service pack. I'm aware I haven't applied the latest Windows SP - I'm deferring IE 7 for the moment.
|||
EDIT
(Windows NT 5.1 (Build 2600: Service Pack 2)
(SQL Server 2000 Original Release 8.00.194 RTM
Database Components SP1 8.00.384 SP1
Database Components SP2 8.00.534 SP2
Database Components SP3, SP3a or MSDE 2000 Release A. 8.00.760 SP3
Database Components SP4 8.00.2039 SP4)
It was reporting both because the first is for Win2k while the TDS number are for SQL Server 2000 Service Pack because it default to 80 and the extra numbers defines the service packs. One more thing build 2600 in Win2k is Advanced Server.
No comments:
Post a Comment