MSDE 2000

MSDN has a new article on how to get MSDE, install it, and use it as your application's database engine: integrate it with Access or SQL Server, manage it with OSQL, implement security and authentication, and do backups and replication. MSDE 2000 does not provide a human interface like SQL Server does with Enterprise Manager/Query analyzer. Users interact with MSDE 2000 through the application in which it is embedded. This article points to resources on how to interact with MSDE server and how to manage it with OSQL.

There is also a GUI tool at The Code Project website which you can download. The source code is also available. I have tried this tool and it's a pretty decent one and allows you to edit your tables, run queries, execute stored procs etc.