service pack 3 for server 2000 1

[occas]

my host has advised me to download service pack 3. at microsoft's site, they advise that if you don't have at least sp1, download it first. how can i determine which sp if any i have? ty.

 

[KatanaCS]

Hi occas,

To answer your question:
SELECT ServerProperty('ProductLevel')

This will return the service pack level. However, Microsoft's Service Packs are almost always cumulative. To quote the main download page for SQL 2000 SP3 (

http://www.microsoft.com/sql/downloads/2000/sp3.asp

):
Because SQL Server service packs are cumulative, SP3a includes all fixes from previously released Service Pack 1 (SP1), Service Pack 2 (SP2), and Service Pack 3 (SP3). SP3a can be applied to an original installation or to one where SP1, SP2, or SP3 was previously applied.

Regards,
KatanaCS

 

[SQLBill]

Check out this FAQ:

FAQ183-3159

-SQLBill

 

[occas]

800.760 but i can't find what that equates to as for sp. ty.

 

[SQLBill]

That is SP3/3a.

Here's the actual link:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24

-SQLBill

 

[occas]

thanks everyone.