I'm trying to upgrade the Default Instance of MSDE 2000 Release A which is
installed with Mixed Mode and strong password to SQL Server 2005 Express in a
Windows 2000 Server with SP4.  On the Upgrade Logon Information screen, if I
select SQL Server Authentication Mode, it will ...

In my daily Server Performance Report, I received two Critical Errors in
Application Log at 3:30 AM every day for about a week. The firsts Source is
MsiInstaller. The Event ID is 100005. The message is:
Product: Microsoft SQL Server Desktop Engine -- Internal Error 2727.

Pardon me for being a bit of a newbie with LCS, but I've run into a few
issues on a recent install.
We have LCS 2005 running on a 2003 Server.  Right now it is the only app on
the server (besides the usual Windows stuff) and the first off when the

I'm having a trouble understanding the redistribution rights for SQL
Express.
Does anybody know if I can redistribute SQL Express on my installation CD?
Integrated into my install?

i accidentally uninstalled the sql server desktop engine (sbs monitoring) and
the sql server desktop engine (sharepoint monitoring) in the add/remove
programs of windows small business server 2003 premium edition..(sp1)
i am using a sql server 2005 developer edition

I try to install BE 10.1.5629 AGAIN on the system.
But it does not work. I have the problem with the MSDE what is needed.
I tried this: http://support.microsoft.com/kb/320873/EN-US/
I tried this too: lodctr /r:perfstringbackup.ini

Does SQL SERVER 2005 Express provide support for use as a backend database
for MS Access 2000 over a network ?

This shouldn't be too hard but I can't find the right answer: How can I
enumerate all databases in my SQL Server (V7)?

I have backed up my MSDE database daily for some weeks with this command in
a .bat file:
osql -E -Q "BACKUP DATABASE MyDB TO DISK = 'E:\MyDB_Backup.MSDE'"
.. however it turns out this this produces some kind of incremental backups,

like in the subject ...
can I expect any performance issues having an virus scanner installed
on the machine together with msde?
TIA

I'm attempting to install MSDE SP3 (and SP4) on a 2000 SP4 Server that is
configured as a file server and a secondary DC/DNS server on an ADS domain
(whose GCS is a 2003 Server).  This is a new installation that never had SQL
installed (I rebuilt this file server recently).  MSDE ...

Hello Group
Does anyone know of a utility or Batch script (osql or Windows cmd or mix)
to Warn an Admin when a MSDE DB is closing in on 2 GB in size (or 2005
Express closes in on 4 GB).

I have a query, generated by Visual Studio.net in an ASP.net web-app which
normally works fine, but occasionally only returns one column of the selected
row.
the first column (Recd_ID) is the identity/key column, and when the query

I have always been told never install antivirus with a sql server.  I believe
this is because antivirus software might interfere or slow down a sql server.
IS the same true for MSDE?  Can someone explian to me why antivirus software
on a sql or msde server is a bad idea.

I installed with DISABLENETWORKPROTOCOLS=0 but I still cannot connect to the
MSDE named instance using Enterprise Manager
The environment is:
Win XP SP2