How to differentiate between an SQL 2000 installation and an MSDE

Hi
Could any one tell me how to diffentiate between a sql instance and an msde
instance
thanks
mmc
hi,
mmc wrote:
> Hi
> Could any one tell me how to diffentiate between a sql instance and
> an msde instance
> thanks
> mmc
SET NOCOUNT ON
SELECT SERVERPROPERTY ( 'Edition' )
http://msdn.microsoft.com/library/de...a-ses_3mi1.asp
it returns "Desktop Engine" for MSDE
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql