Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)

Author  Topic 

Starting Member

14 Posts

Posted - 2008-10-06 : 05:42:07
I want to know the major limitations of MSDE 2000 w.r.t SQL SERVER 2000.i have a cooperate database application running on SQL SERVER 2000.Can I use MSDE instead of complete SQL SERVER 2000 to support this database application.

Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-06 : 05:44:36
Depends on the features you want to use. MSDE is a lightweight db which has now been replaced by the MS SQL express versions
Go to Top of Page

Aged Yak Warrior

652 Posts

Posted - 2008-10-08 : 16:13:46
The 2GB limitation on MSDE/Sql express is not designed to run major cooperate apps.
Go to Top of Page

Dr. Cross Join

7423 Posts

Posted - 2008-10-08 : 20:26:36
Use SQL Express, there is really no reason to use MSDE that I can think of instead of SQL Express. This entire website -- -- runs on SQL Express.

- Jeff
Go to Top of Page

- Advertisement -