of couse not ... MSDE is free .. but in SQL Server 2000 Developer you pay many to get licence (per seat [cheap] or per server)

here is wat you want:

How can I completely uninstall SQL Server?

If the standard un-install utility doesn't do the trick for some reason :-

Remove the...

you can install (client tools) which include EM from any SQL Server CD .. by moving in installation as you make a server .. but choose (client tools)

I hope this help...

why you get tables names from msysobjects ?

there is another solution .. to put names of your tables into a new table and query this table ...  

this problem happens to me before because I install MSDE .. then remove it then install SQL Server 2000 Developer edition.

I think the problem happened because of comparing OLE DB...

yes you have to make full bakup daily .. and bakup log every 1 hour .. so your transaction log does not grow by large amount.

I want to ask Kevin about his idea of File DSN ... does it support a lot of user connected to it (above 30 users) without crashing?

also is it faster than...

I think the minimum amout of memory is 512 MB RAM..

Also SQL Server is Monister in dealing with Memory .. because it takes almost all the memory you give to...

does your SQL server has its SP3a ?

also install Mdac 2.7 SP1 on it

I hope this solve the problem

try to install SQL Server SP3a ..

then install MDAC 2.7 SP1

I hope this solve the problem

of course install SP3a for SQL Server 2000 or SP4 for SQL Server 7 ..

SP solved many problems.

I think you have to use "Performance" tool in Windows and add counters of network ..

also check that yout TCP/IP and named piped are enabled in both Client Network utility...

you have to attach your user DB again (it is found as it is in your HDD) ..

also, in EM .. if you see the properties of your server .. under (server settings) there is the default language for user .. which will be the default language...

Note : you have to install MDAC on all the clients and SQL Server machines

and I think MDAC 2.7 SP1 refresh version is a very good one.