How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thanks
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>