Appendix C. Microsoft Data Engine (MSDE)
MSDE is a scaled-down version of the SQL
Server engine that's free to install and distribute.
It's similar to SQL Server, except for a few
It supports only five simultaneous users.
It doesn't include any graphical tools to help you
design tables, monitor performance, and perform general database
maintenance. However, you can use Visual Studio .NET and its Server
Explorer to gain some basic database manipulation abilities.
It can't host a database larger than 2 GB.
MSDE is an ideal platform for testing ADO.NET code if you
don't have a SQL Server database handy. You can even
install it alongside an instance of SQL Server if you
don't want to test with a production server. Best of
all, databases created in MSDE can be easily migrated to a SQL Server