How to tell if server is MSDE or Full MS SQL Server?

Hello all,
Is there away to query the server, a registry setting or some other method
to tell if the the server is MSDE or SQL server 2000?
Thanks,
Bill
SELECT SERVERPROPERTY('Edition')
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill D" <Bill@.test.com> wrote in message
news:#r8s$u5gEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> Is there away to query the server, a registry setting or some other
method
> to tell if the the server is MSDE or SQL server 2000?
> Thanks,
> Bill
>
|||hi Bill,
"Bill D" <Bill@.test.com> ha scritto nel messaggio
news:%23r8s$u5gEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> Is there away to query the server, a registry setting or some other
method
> to tell if the the server is MSDE or SQL server 2000?
> Thanks,
> Bill
>
SELECT SERVERPROPERTY('Edition')
http://msdn.microsoft.com/library/de...a-ses_3mi1.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Also you can run
Select @.@.version in query analyzer
This will give you additional information about the SQL Server build number
and operating system version information along with the SQL Server addition.
Tom
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.