sql server msde: Hello

In a backup program, I need to know if MSDE is installed locally.

If I knew the computer's name where MSDE is installed, it will be perfect!

Does somebody have an idea?

hi Sylvain,
[quoted text, click to view]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_3mi1.asp
SELECT CONVERT(varchar(20),SERVERPROPERTY('MachineName')) AS [Machine Name],
CONVERT(varchar(20),SERVERPROPERTY('ServerName')) AS [Server Name],
@@SERVERNAME AS [@@ServerName]

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply