Page 46 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes 3.1.3 Showing Additional Windows

Notes Users familiar with the SQL Server Enterprise Manager of SQL Server 2000 may
wish to show the Registered Servers window.
To show the Registered Servers window

1. On the View menu, click Registered Servers.
The Registered Servers window appears above Object Explorer. Registered Servers lists
servers which you manage frequently. You can add and remove servers from this list. If
SQL Server 2000 Enterprise Manager was previously installed on this computer, you will
be prompted to import the list of registered servers. Otherwise, the only servers listed are
the SQL Server instances on the computer where you are running Management Studio.
2. If your server does not appear, in Registered Servers, right-click Database Engine, and
then click Update Local Server Registration.

Self Assessment

Fill in the blanks:
1. Database information is shown in ……………………. and document windows.
2. The ……………………. is the largest portion of Management Studio.

3. ……………………. is a new tool for SQL Server database administrators and developers.
4. Object Explorer includes information for all ……………………. to which it is connected.
5. The Registered Servers window appears above …………………….
6. Registered Servers lists servers which you manage …………………….
7. By default, the Object Explorer Details page is displayed, connected to the instance of
……………………. on the current computer.

3.2 Log File Viewer

Log File Viewer in SQL Server Management Studio is used to access information about errors
and events that are captured in the following logs:
Audit Collection
Data Collection
Database Mail
Job History
Maintenance Plans

Remote Maintenance Plans
SQL Server
SQL Server Agent
Windows NT (These are Windows events that can also be accessed from Event Viewer.)

40 LOVELY PROFESSIONAL UNIVERSITY