SQL Server  «Prev 

Console Root Enterprise Manager

Microsoft Management Console (MMC) is a tool that presents a common interface for managing different server applications in a Microsoft Windows network. Server applications provide a component called an MMC snap-in that presents MMC users with a user interface for managing the server application. SQL Server Enterprise Manager is the Microsoft SQL Server MMC snap-in.
SQL Server Enterprise Manager is the primary administrative tool for SQL Server and provides an MMC-compliant user interface that allows users to:
  1. Define groups of SQL Server instances.
  2. Register individual servers in a group.
  3. Configure all SQL Server options for each registered server.
  4. Create and administer all SQL Server databases, objects, logins, users, and permissions in each registered server.
  5. Define and execute all SQL Server administrative tasks on each registered server.
  6. Design and test SQL statements, batches, and scripts interactively by invoking SQL Query Analyzer.
  7. Invoke the various wizards defined for SQL Server.

The highest level of objects within the Enterprise Manager is the Console Root
The highest level of objects within the Enterprise Manager is the Console Root

Below the console root is a list of SQL Servers; each with its own folder. Most often, you will want to look at the database foler.
Below the console root is a list of SQL Servers; each with its own folder. Most often, you will want to look at the database foler.

Under the Databases folder, you see every database that you have created on a specific server.
Under the Databases folder, you see every database that you have created on a specific server.

If you drill down the database, you will see the hierarchical list of objects contained within it
If you drill down the database, you will see the hierarchical list of objects contained within it.