Can I connect to MSDE through Enterprise Manager from another machine?

In MSDE, since there is no sql mail, I am thinking of doing the following:
1. write a shell script which will query the sysjobhistory table to
determine if any job failed. If so, then an email about the failure is sent
out.

I cannot install MSDE on a machine.   If I run the following it does
nothing:  Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
Do I have to completely clean the machine first?
Any suggestions?

I want to install multiple instances of MSDE on XP prof edition. How many
instances can i create on a single machine?
Also, any URL for this would be helpful?
Thanks,

When attempting to install MSDE 2000a to a machine running XP Pro SP2, I get this error message:
2005-01-21 08:56:55.75 server    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05
    Copyright (c) 1988-2003 Microsoft Corporation

I have a windows 2003 ent server that we cannot install MSDE on.
If we run this from terminal services and a command line, we get nothing:
Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
Not even a log file.

When installing an app, what would you need to check in order to determine:
1. If MSDE is installed.
2. If a specifically named instance of MSDE is installed.
Thanks.

I was able to install MSDE into WXP and migrated my Access
databases through Windows Integrated Authentication Method.
But whenever I tried connecting to MSDE by SQL login it
gives me the following error:

I have a client running MS Windows 2000 with MSDE 2000 (Build 2195:
Service Pack 4) installed on local machine. My program connects to the
SQL using "(local)" as server name.
After working some time in the program (running queries, everything is

I using MSDE and it works fine in winXP and Win2000.
Now im trying to work with Win98 and it gives me this
message "Login Fail for user Null - Not associated with
trusted SQL"

I am trying to determine how to differentiate a SQL 2000 and MSDE install
without running a query on the database.
In mmc's post and Andrea's answer on 1/18/05, a clear solution using a query
is noted.

I would like to modify the amount of backups that  the sql server keeps on
record.  My reasoning is that I am trying to minimize the size of my full
backups. I was made aware that  the server keeps a certain time period of
backups and that I could modify this and lessen the time ...

I have a program installation setup that comes with a default MS Access Database. How do I attach this default database into MSDE on my server?

When I send a query 'SELECT somedatecolumn FROM....' I got resultset
containing datetime. It's ok because it is a datetime field (or
smalldatetime) but it is a little frustrating because I'm interested only in
date. Is it possible to get only a date, without the time? My previous

I have a .SQL script file that contains database definitions.  How can i run
the .sql script file to add this database to my MSDE SQL server?
Thanks for your help
mustafa