How to tell what service patches are applied

I am trying to confirm that our SQL Server 2000 machine has SP3 installed.
When I click on the SQL Server Properties for the local machine when using
SQL Server Enterprise Manager it says that the prodict is 8.00760(SP3), but
when I look at the error log it shows:
2006-01-09 06:58:04.87 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
So which is correct? Are we running SP1 or SP3?
Thanks...
Looks like 3 for SQL server and 1 For Windows
run this
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
SERVERPROPERTY( 'ProductLevel') AS ServicePack
http://sqlservercode.blogspot.com/
|||Steve,
the SP1 message is the service pack version of Windows
> on Windows NT 5.2 (Build 3790: Service Pack 1)
Your SQL Server is SP3
Markus
|||Thanks for the quick responses. This is what I needed to know!
"MarkusB" wrote:

> Steve,
> the SP1 message is the service pack version of Windows
> Your SQL Server is SP3
> Markus
>