Using the Enterprise Manager with MS SQL Server

Previous  Index  Next  How To Use

From the Enterprise Manager, you have access to all functionality related to MS SQL Server.

 

In the Servers treeview, expand the registered server. This will show the following treenodes:

 

An expanded MS SQL Server

 

Databases

This node lists all available on this server.

 

By using the context menu on a database, you will get several additional options:

 

The Context Menu for a Database

 

For information on the functionality in this menu, see:

Database Properties
Detach Database
Take Offline/Bring Online

 

Management

This node lists several shortcuts and actions to management-related tasks for MS SQL Server. Currently, the following are available:

Server Logs

 

Security

There are links available to the Login Manager, Server Roles and Linked Servers Manager.

 

Activity

Activity - Processes
Activity - Locks/Process ID
Activity - Locks/Object