I can't create a db because my doc.mdf already exists.
I've stopped the server, deleted this file as well as it's related file and
made a new db but now I don't know where the two new files are located.
They are not in the same directory as the other dbs.

I've read that MSDE will cease to be supported and developed from 2007 some
time.  What is the alternative DB to use once this happens?  Is there a
MSQLFree for example?
cheers

I'm using McAfee ePO here which uses an MSDE database. I am trying to run
the recommended maintenance command on the DB but keep getting an error. It
seems to be related to the -U and -P account I'm using but I've tried every
variation of user and password it could be including ...

I'm familiar with ms access, but not with msde and ms adp type projects.
Is the adp file similar to a frontend in access and the sql server tables
the backend so I would distribute the adps to the workstations.
If so, how do I link to the sql server from another workstation.

I downloaded SQL Server 2000 Service Pack 4 and installed. I setup it up by
typing in the command line:
setup SAPWD=”sapass” SECURITYMODE=SQL  
It started but up to "Gathering required information", an error box poped up

I have a small problem and I suppose the solution to be very simple but
I don't find it and I'm blocked.
I have to build a query that will merge some information from a database
of a provider and our sql server. When I test the query, it returns me

I am using xp_cmdshell bundled with SQL2K to copy a file from one
location to another on the same machine. This sometime works and
sometimes fails and return an error code as 128. The documented return
codes of this extended procedure is only 0(success) and 1(fail).

I have a fairly large database that takes up around 7GB of space on my hard
drive and on top of that, one of the tables in the datatbase with about 25
plus columns has 4 million rows.  The problem I am getting is whenever I
restart the SQL Server service or at bootup, my database ...

I have had MSDE installed and running for some time and a few days ago  I
installed Microsoft Visual Studio.Net 2005.
During the installation, MSSQLExpress was installed so I think that I have
two engines running.

I've just started dabbling with SQL Express (I've an up-coming project and
would like to use it). I had no hassles connecting to the db I created in
VS2005 std but now I want to test connectin to it outside of the inetpub. I
copied the MDF and LDF to another folder on my drive and ...

Has anyone out there began research on what to do after MSDE is no longer
supported after 2007? I am concerned about products that I have it integrated
into after this date. I can not find any clear explanations about the legal
implications of this. Has anyone seen any definitive ...

Does anyone know if it is possible to apply Failover clustering service over
2 servers with MSDE?

I am building an application with a SQL Server 2005 Express backend. I
would like to create a secondary instance the database on another
server that will serve as a fail-over in case the primary server goes
down (there is only the Express version of SQL Server in this picture).

How does the MSDE and SQL Server 2005 Express calculate the database size for
the 2GB and 4GB limit respectively?  Are they based on database size or just
the allocated part of the database size?  Does it include log file size?
I want to write a script to check whether a database ...

I'm an ISV, and currently the main "shrink wrap" application that I develop
uses MS JET 4.0 as the backend database.  My application's "document" is
just an mdb file (with a file extension that is associated with my app).
Deployment is quite simple, and from my users' perspective ...