SQL Service Packs confusion

[PhilCo126]

We're testing Win Sharepoint Services (on a Test-server so we don't have to mess up our running SPS environment :D ) WSS 3.0 and only have SQL Server 2000 Enterprise ( WSS 3.0 better runs with SQL 2005 I guess )...

We've installed SQL Server 2000 but I'm confused on the available Service Packs:

Service Packs for SQL Server 2000

ServicePack 3

Sql2kasp3
Sql2desksp3
Sql2sp3 ( I guess this one )

ServicePack 4 ( not necessary for servers below 2 Giga RAM memory )

SQL2000-KB884525-SP4-x86-ENU.exe

:confused:

[russell]

if running sql2000 enterprise, apply sp4

[PhilCo126]

Same deal for SQL 2000 standard ?

[russell]

definitely. version should be 8.00.2039 after SP4 applied

who told u sp4 not necessary for server w/ less than 2Gb ram? should definitely apply in either case.

[PhilCo126]

Thank You!

UPDATE: Microsoft has found an issue with the final build of SP4 that impacts customers who run SQL Server with AWE support enabled. This problem does not affect ia64 platforms. On x86 and x64 systems, the problem only impacts customers with more than 2 gigabytes (GB) of memory (available only with the Enterprise, Developer, and Evaluation editions) where AWE has been enabled and more than half of the total system memory is being allocated to a single SQL Server instance. Customers with this configuration should obtain and apply the hotfix specified in article 899761 of the Microsoft Knowledge Base after upgrading to SP4.

[russell]

yes, thats post SP4 hotfix for AWE issue. Not an issue if < 2Gb or running SE. But still should apply SP4 in any case.