Today i faced the following issue : An MSDE Database I had been working
on in the morning in  order to be able to upgrade our software,  with
the statement:
Through Osql :

I installed MSDE 2000. I dont see the enterprise manager though? How to I
restore 2 databases which I need to. I know we can do this with enterprise
manager in sql server 2000. How do I restore and see the database with MSDE
2000??

May I install Enterprise Manager on an MSDE Machine with no licensing
issues?
Thanks,
Mac

Have a question - is SQL server 2005 express and MSDE coexist on the same
computer, seems like i have some trouble accessing 2005 in the right way
from VS 2003, and if not - any recommandations around management software
for MSDE?

I am developing an app that uses a sql server backend but also need to run
queries on temporary data tables.  In order to reduce network traffice, I
want to do this on the  workstations rather than passing all the work over
the net.  Since msde does not come with development ...

I am running a stand-alone test environment for an application in XP Pro
which I can only use MSDE to manage my databases.
I've successfully installed msde and am finally able to connect using 'osql
-Usa -Ppassword -S (local)\testmachine' , because I can get the '1>' command

I'm just curious, can MSDE and SQL Server exist together on the same box?
I'm using MSDE now and want to add a SQL Server onto that same box. MSDE db
is in use.
Many thanks,

On my computer I have installed two instances of SQL Server 2000. The first
one is the default instance of SQL Server Personal Edition and the second one
is an MSDE instance.
From other PCs on the company LAN I can connect, by name, only to the first

I have been tring to install the MSDE 200Aon my marchine that is using
the command prompt.
this is the command that i was using:
(setup INSTANCENAME="SA" SECURITYMODE=SQL SAPWD="SqlAdmin1"

Is there a way to get MSDE to work across multiple profiles?  I've
discovered that if one user installs an instance of MSDE, then no other
users who log into that machine can create databases.
Is there a flag or installation setting I need to configure to get it to

If the only application using MSDE on a give machine is closed, can I simply
FTP the *.mdb and *.ldb files to a remote location for backup?
Thanks ,
Mac

What is the recommended method to import an Excel spreadsheet into a
SQLServer table.  I'd like to write a VB function activated by a button press
by the user to perform the import operation.
Thanks!

I'm taking a web application that was connected to SQL 2000 Std Ed and
making a desktop version out of it.  It will be Windows forms connected to
local databases created on the fly.  Does anyone have advice for the best
way to replace the stored procs?

i have problem installing MSDE 2000a on server 2003 R2. The problem is that
installation is starting but then at the end just roll back and get this two
event log:
Event Type:    Error

I currently exclude the directories that contain the sql database files
(mdf, ldf) from my antivirus 'real time protection' and scheduled sweep
scans. Actually I do this for any database files (act, quickbooks, ms
access) but I was recently thinking about this and I realized that ...