How compatible is MSDE 2000 with SQL Server 2000?

Will any application developed against SQL Server 2000 DeveloperEdition work on an identical platform with only MSDE 2000 installed? Iunderstand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apartfrom that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) thatare "disabled" in MSDE 2000?
See theChoosing an Edition of SQL Server 2000 whitepaper for explanations of each of the SQL Server versions. Also check out Features Supported by the Editions of SQL Server 2000.
The Developer Edition has essentially the same features as theEnterprise Edition. As far as I understand it, MSDE basically hasthe same features as the Standard Edition (with exceptions). Theabove links go into more depth.
I believe that for most normal .NET applications you will not have a problem with missing functionality.
sql

How can i use embbed sql(e.g. SQC) program to access MSSQL from linux or unix?

hello all!
Help!
I've a lot of programs written in sqlc to mssql on the windows platform.Now the boss wants to use linux server and I've to tune all my programs in sqlc to linux.But how to do it?Does anyone help me?Don't have any experience in linux, thought this link (http://www.linux.org/apps/AppId_8044.html) may give you required information.

HTH|||Thanks, but this link was on MySQL, not MSSQL. I also have some information on this through using freeTDS or DBI, but on embedded sql, I found nothing!:(|||Then may be you need to do other way round, how about this link? (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=921&lngWId=8)