To verify whether SQL Server or MSDE is installed on your computer, follow these instructions:
- Right-click the My Computer icon.
- Select Manage.
- Double-click Services and Applications.
- Double-click Services.
If MSSQLSERVER is in the list of services, the default instance of SQL Server or MSDE is installed on the computer. Other instances may exist, in which case they will be listed as MSSQL$**, where the asterisks indicate the name of the instance.
SQL Server and MSDE management
Unlike SQL Server, MSDE does not ship with its own Enterprise Manager tool. Developers and users of MSDE applications often need third-party tools for database design, management, and administration. Modern SQL clients like Beekeeper Studio can be used to manage these databases effectively.
Source: Microsoft website
Beekeeper Studio Is A Free & Open Source Database GUI
Best SQL query & editor tool I have ever used. It provides everything I need to manage my database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio is fast, intuitive, and easy to use. Beekeeper supports loads of databases, and works great on Windows, Mac and Linux.
What Users Say About Beekeeper Studio
"Beekeeper Studio completely replaced my old SQL workflow. It's fast, intuitive, and makes database work enjoyable again."
"I've tried many database GUIs, but Beekeeper strikes the perfect balance between features and simplicity. It just works."