are we running Enterprise or Standard

How can I tell if we're running the Enterprise or Standard or Developer
version of SQL Server 2000?
Thanks,
DanHi,
Execute the below command from query analyzer:-
select @.@.version
(In the final line it say "Personal Edition on Windows NT" -- incase of
personal edition)
In sql 2000, you can execute the below command as well:-
Select serverproperty('edition')
Thanks
Hari
MCDBA
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>|||Try:
SELECT @.@.VERSION
or
SELECT SERVERPROPERTY('Edition')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>|||Thanks Dan and Hari. The serverproperty is just the right thing. Using
@.@.version produces a line so long I have a hard time finding the end of it.
Dan
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ukVzsvOOEHA.2952@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Execute the below command from query analyzer:-
> select @.@.version
>
> (In the final line it say "Personal Edition on Windows NT" -- incase of
> personal edition)
> In sql 2000, you can execute the below command as well:-
> Select serverproperty('edition')
>
> Thanks
> Hari
> MCDBA
> "Dan" <ddonahue@.archermalmo.com> wrote in message
> news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > How can I tell if we're running the Enterprise or Standard or Developer
> > version of SQL Server 2000?
> >
> > Thanks,
> >
> > Dan
> >
> >
>