Maximum user connections: 5 before the work load governor will limit the performance.Maximum number of processors: 2 in NT/Win2000/XP/2003, 1 in Win98/ME.Graphical DBA, and developer utilities and wizards.There are some limitations to a MSDE database.
The database does not have to be installed on the hard drive on the deployment computer, but it could be running from a CD-ROM. An MSDE database is a good and affordable starting point for any business, organization or even home solutions. Among the choices are, a standard edition or an enterprise edition. The database is limited to 2 GB of data storage space, but you can easily upgrade it to a full Microsoft SQL Server without any limitations. It is ideal for small websites and small businesses with less than 25 simultaneous users. The MSDE database is free, and can be distributed embedded in your own applications or as a small stand alone SQL server. In short, it is the Microsoft SQL Server 2000 database engine without any of the fancy UI tools, and with some limitations in the database size and the number of connections.
MSDE is a limited version of the Microsoft SQL Server.
HOW TO UNINSTALL MICROSOFT PROJECT ON WINDOWS 10 HOW TO
How to list all users and roles in a database.How do I list all tables in a database?.How do I attach a database to the system?.How do I detach a database from the system?.How do I list all the databases on the system?.How do I determine what version I am running?.Below you will find an overview of the topics. This article describes how to configure the Microsoft MSDE database engine.