Can i use sql server 2005 express instead of MSDE2000 ?
My applications connect using TCP/IP
I have some third party MSDE2000 administration tools, will the work with
SQL 2005 express ?

I'm using Access as a front end to MSDE 2000. What is the best way to
shrink the database using code?
Presently I'm using a stored procedure called from VB, however error
3251 is generated and the database is still shrunk. It works, but I

I am running a default instance of SQL Server Developer 2000 SP 4 on a
machine.  I installed a Named Instance of MSDE SP3 on the same machine.  
Everything was fine, then I uninstalled the MSDE Named instance.  I rebooted
the machine and when I open Enterprise Manager, I can not ...

Howdy,
I just accidently wiped out a table that had some pretty important data in
it. Can I restore it from the transaction log? Here's what I've tried so far
and I get the errors as stated below. I did do "net pause mssqlserver"

I'm in the process of learning T-SQL while using MSDE 2000 SP4 with
Access 2002 and the NorthwindCS.adp database.  I've purchased the "SQL:
Access to SQL Server" published by Apress. Unfortunately the code for
the chapter is not included in the download file from

Vorrei configurare il file .ini del setup di MSDE in modo tale che dopo
l'installazione tutti e tre i servizi di SQL:Sql Server, Seql server agent e
ditribuited transaction ... si avviino automaticamente all'avvio del
computer, qulcuno sa come fare ?

Hello, folks.
   Don't laugh!  I am still dealing with customers who are still using
Win95 and WinNT4 primarily in  hospitals that are stuck with old
equipment and operating systems.  The company I work for uses MSDE 1.0

I need to backup a MSDE database with
sql -E -q "BACKUP DATABASE <database name> TO DISK = 'E:\Database.BAK'"
- but I don't know the name of the database.  I have tried with '*' without
success (as I know there is only one database).  However how can I list the

Hi there, i have searched for an answer to my question but can't find
one anywhere so far, hopefully this is the right place to post such a
question, thanks in advance for any help you can give me!
I've just moved our company DB from access to msde and while its gone

Hi peeps
Ok, we have an instance of MSDE running several databases, which is
installed on the C: drive (c:\MSSQLSERVER$INSTANCE).
Because of space problems on C:, we want to move the entire Instance

I need to set security for row level but not based on Database user's
login. It should be based on the user table login. For the particular
user I need to allow only the particular records to access insert,
update delete and select.

We are trying to move our Sharepoint MSDE database from our C: to a new
local drive P:
The KB article 833797 has a walkthru but we keep getting incorrect
syntax errors. We've tried to nest using the ' character in many ways

I am attempting to install MSDE 2000 SP4. Here is my invocation:
setup DATADIR="D:\" SAPWD="xxxxxx" DISABLENETWORKPROTOCOLS=0
It fails with the following error:
"Setup failed to configure the server."

Hi my Friends. I need to convert a mysql database(structure and data) to a
sqlserver database. Have you something (a document, a example) that explain
how I do it?
thank you

I'm trying to Insatlling MSDE 2000.  I want to install it on a praticualr D
in this case the D drive instaed of C.  How can I do this?