MS SQL Enterprise Manager is a powerful tool. But if you are looking for some administration tool for MS SQL / MSDE go for EMS MS SQL Manager.
It comes in two versions Professional & Lite (Compare). It’s a powerful database management tool with:
- Easy Management of db objects
- Advanced Data Manipulation Tools
- Powerful Security Management
- Visual / Text tools for Query building
- Data import / exports
- Administrative Tasks
- & tons of other features
EMS MSSQL Manager Lite for Windows is free. You can download a copy from their website.