Using the Enterprise Manager with MS SQL Server

Previous  Top  Next

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



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



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

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



The fixed Server Roles are listed here and there's a shortcut to the Login Manager.