how to tell SP level?

How can I tell what level of service pack is installed on
a machine?
TIA,
AdriaAdria,
Refer the below article to find SQL Server service packs
How to identify service pack in 6.5/7/2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria|||in QA, connect to the SQL server you want to check and type
use master
go
select @.@.version.
It will pull version of your SQL server. then go to link
below and find out what SP is installed.
http://support.microsoft.com/default.aspx?scid=%2fsupport%
2fservicepacks%2fSQL%2f2000%
2fSP3ReadMe.asp#_details_of_database_components_sp3_install
ation
Gook luck.
>--Original Message--
>How can I tell what level of service pack is installed on
>a machine?
>TIA,
>Adria
>.
>|||http://www.aspfaq.com/2160
"Adria" <a-carbo@.tamu.edu> wrote in message
news:0c0001c361c4$1c712fd0$a001280a@.phx.gbl...
> How can I tell what level of service pack is installed on
> a machine?
> TIA,
> Adria