service pack in SQL

How would i find out whhich service pack applied to a sql server 2000?

Thanks in advance!!!

select @@version will tell you.

example

http://www.krell-software.com/mssql-builds.htm

If you see numbers above 8.00.760 it means those are hot fixes like




Microsoft Knowledge Base Article - 821334

Microsoft Knowledge Base Article - 831997

Microsoft Knowledge Base Article - 838460

Wish list......

Microsoft should organize their SQL Server Website with all the SQL related SPs and Patches in the same page with KB articles.

Thanks

Use any one of these:

SELECT SERVERPROPERTY('ProductLevel')

master..xp_msver

select @@version

That's great, thanks a lot!!!