SQL Server Management
SQL Server management consists of using a lot of different tools - especially for different versions and editions. There's no one SQL Server management console: database administrators have to use multiple management tools.
The newer versions of the tools can manage older SQL Server versions. On your desktop, use the latest version of the tools to manage all of your servers where possible.
To use and configure these tools, here's a few articles:
SQL Server Management Studio - Express
If you use SQL Server Express Edition (as opposed to SQL Server Developer Edition), it may not come packaged with SQL Server Management Studio. There's a free version of SQL Server Management Studio Express that you can download to administer your SQL Server Express instances. Here's some links on those editions:
SQL Server Management Studio 2005 and 2008
SQL Server 2005 and 2008 come with SQL Server Management Studio, a replacement for Enterprise Manager and Query Analyzer. This tool helps you manage your databases with point-and-click ease and T-SQL capabilities. For information on how to use SSMS, check out these articles:
SQLServerPedia Editors Top Picks for Administration