Is SQL 2005 Express compatible with WSUS?

I try to start and stop specific instances of MSDE using SCM.EXE
This works for the default Server, but not for a specific one.
This works:
SCM -Action 6 -Service MSSQLServer

I took the SP4 MSDE and tried to publish sql2000.msi to active directory but
it failed.
When I ran the MSI file interactively it complained about not finding the
default instance. Obviously setup.exe must set this property?

I select New Stored Procedure from the context menu of the stored procedure
tab in my database, and it procedes to makes a file called SQLQuery1.sql and
saves it as a file, but doesn't add it to the list of my stored procedures...
How do I add it? What am I doing wrong? I see no ...

I'm using MSDE 2000 SP4. I need to get only date from smalldatetime
using SQL statement like "SELECT MyDate FROM MyTable.".
Like this way I'll get MyDate as "27.11.2005 0:00:00" when using finnish
regional settings, but how to get just "27.11.2005" without that empty time?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.

I am trying to install MSDE Rel A on a Windows XP SP2 machine with no luck no
matter what I try. I am typing the following at the command line.
setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL
Below are the portions of the error log that contain RETURN VALUE 3,

I have installed MSDE 2000 RelA. on pc with Windows XP.
The problem is that when I run the SQL Server Service Manager, there are no
choices in the field Server. When I'm writting the ComputerName\InstanceName
everything is ok, but why is this happening? There are many times where I

I am in the process of downgrading an MSDE database to a Jet (Access)
database for the following reason:
1. Size: Deployment of an MSDE database engine is inflating my distribution
file (Setup.exe) over 20 Megs! With an Access database this number is ZERO

Is the new version of SQL 2005 (Express) compatible with Windows
Update services?
TIA
Regards,

I just can't get MSDE installed on my machine. It hangs midway through
the process. If I kill setupre.exe the setup continues but just before
it's done there's an error "Setup failed to configure the server", and
it rolls back. I've stopped the services and processes and read the

Am I looking in the wrong newsgroups, there is msde newsgroup, but I cannot
find a sqlexpress . Should I post questions about sqlexpress in the msde
group or where?

I have done lot of R&D on different databases
Including MSDE.
@ Last I found one which is really cool -- FIREBIRD
(Dont consider me as a Database Guru)

Hello, would SQL Express 2005 be a viable solution then for a website that
uses DNS connections for a traffic of 100,000 pages downloaded per day?
Thanks              Stephan

is there a way to schedule a backup ?
Using the Management Studio Express I've seen only the way to Backup a
database but not to "schedule" a backup.
Any help or suggestion is appreciated