Determine ServicePack level

Hello,
how one can determine ServicePack level of SQL Server 2000 installation? I
would like to do this without server running (not neccessary, but
preferably).
Nice day
Ondra.Have a look here:
http://vyaskn.tripod.com/sqlsps.htm
--
Andrew J. Kelly
SQL Server MVP
"Ondrej Sevecek" <ondra@.sevecek.com> wrote in message
news:u2F33DZaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> Hello,
> how one can determine ServicePack level of SQL Server 2000 installation?
I
> would like to do this without server running (not neccessary, but
> preferably).
> Nice day
> Ondra.
>
>|||Ondra,
Without the SQL Server running? May be you can check the SQL Server errorlog
(C:\Program Files\Microsoft SQL Server\<instancename>\LOG).The first section
is the output of @.@.version.The numbers in the first line indicate the
service pack level.
- 8.00.760(SP3/SP3a)
- 8.00.534 (SP2)
- 8.00.384 (SP1)
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Ondrej Sevecek" <ondra@.sevecek.com> wrote in message
news:u2F33DZaDHA.1832@.TK2MSFTNGP09.phx.gbl...
> Hello,
> how one can determine ServicePack level of SQL Server 2000 installation?
I
> would like to do this without server running (not neccessary, but
> preferably).
> Nice day
> Ondra.
>
>