SQL Server 2000 Administration in 15 Minutes a Week: Enterprise Manager Introduction
May 24, 2002
If you have ever used the Microsoft Management Console (MMC) you will notice that the Enterprise Manager looks familiar. This is because the Enterprise Manager is a MMC snap-in like many of the tools provided with Windows 2000. If you would like more information on using the Microsoft Management Console have a look at the following link:
By expanding "Microsoft SQL Server" and then expanding "SQL Server Group" you can locate the SQL Server you have installed on your local system. Expanding the tree further allows you to manage databases, security, replication, etc.
Right clicking the SQL Servers icon in the tree view will also popup a menu with options that allows you to start/stop the server, view the server messages, access the server's properties, etc.
Enterprise Manager also provides you with a quick look at the status of your SQL Servers. Depending on the icon displayed in the tree view you can tell if SQL Server is running, stopped, paused, or if you are currently connected to the server. Use the following table to check the status of your SQL Servers:
The Server Groups screen allows you to create new groups as Top level (under "Microsoft SQL Server") or as a Sub-group under an existing group.
Enter a name for the group in the "Name:" textbox and click OK.
You can continue to add Groups and Sub-groups until you have the ideal layout for your organization.