How to verify the Service Pack I applied before?

How to verify the Service Pack I applied before?http://www.aspfaq.com/2160
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>|||>--Original Message--
>Hi,
>Execute the below command from Query analyzer:-
>-- FOR SQL 2000
>select serverproperty('ProductLevel')
>
>-- For SQL 7 and old
>Select @.@.version
>Get the version number and look into below site for
service pack .
>http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
>
>Thanks
>Hari
>MCDBA
>
>"Julia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
>.
>sql