I need to connect an msde 2000 database to sql 2005 express without upgrading
the database itself.  Here is what im running into at the moment.  I have an
msde 2000 database that has torn pages so its pretty much pooched.  I have
connected it to a msde 2005 (sql 2005 express) in ...

I've got an applicatipon that was recently updated from MSDE 2000 to SQL
Server Express, but I'm beginning to see that more and more as a bad move.
Is there any information about storage efficiency of various SQL Server
versions?  I'm getting extremely poor results with SQL Express.

I would like to have a ODBC connection to a MSDE 2000 database on a Win 2003
server from a client PC. Can this be done?
On the client I can browse to the the SQL server, but I cannot connect to
it. Is there a way to connect and retreive the data ?

I have a BCM database created using SQL Express that I want to Attach to  a
SQL 2000 server. Is there any way I can do that?

Trying to develop a trigger - what is the best way to debug a trigger? Any
log files or query analyzer available to assist in debugging.
Thanks
Dan

I have a SQL 2005 Embedded database that was created by SharePoint Services.
It's ldf file has grown to almost 3 gig, and I need to move it off the C
drive. I have successfully moved some of the other databases using the OSQL
command, but when I try to move this one particular ...

I have a fairly heavy duty app that can use SQL2005, however I am getting
some rather strange behaviour, if MSDE or SQL2000 is used, this doesn't
appear to happen.  Here's what happens:
The VB6 application makes fairly regular calls on the database (only when

If after installing and working with MSDE a long while ago I forget the
instance Name in my local machine, what could I do to find it out again?

   I know that MS SQL Server 2000 versions (including MSDE) are not
supported on Windows Vista, but still I'd like to ask if anyone knows
why when MSDE is installed on Vista, each time after a user logs in
to Windows, the instalation dialog appears for few seconds.

Hello NG,
i have several problems at some computers. the user is in a group
called "group1". the group1 has privileges to start/hold/stop this
services:

I am a complete neophyt to SQL.  I am attempting to restore a backup from a  
MSDE 2000 SQL server from a peer to peer server to a server running Small
Business Server 2003 using OSQL.  (In other words I’m moving the database to
a dedicated server.)  I performed a RESTORE DATABASE ...

Hey there,
we're having an issue with the SQL (MSDE) database that sharepoint uses.
The service starts and immediately stops. In the logs (in dutch) there's
an error: "Het checksumbestand van de systeemdatabase heeft een

I normally keep my MSDE server stopped and start it only when I run the app
that uses it (otherwise, my corporate backup prog complains abt files in use
being not updated).
How can I start my MSDE through a command line so that I can include it in a

I'm trying to attach a MSDE 2000 database to SQL Server 2005 Express.
I simply issue sp_detach_db XXX where XXX is the name of my MSDE database.  
Then sp_attach_db or create database ... with attach and both way gets the
following message:

I have tried to setup my SQL Server Browser to Network mode but I keep
getting an error saying "WMI Provider Error", "Can't add or remove a member
of the local group because the member does not exist"
Very strange error. What can I do to be able to set it to network mode?