Using the Enterprise Manager to Perform Common Tasks
The following sections provide brief descriptions of how to perform common administration tasks from the SQL Server Enterprise Manager. Many of these tasks are explained in greater detail in other sections of this book.
Manage Server Configurations
Follow these steps to configure a server:
1. |
From the SQL Server Enterprise Manager, right-click the server you want to configure.
|
2. |
From the menu, select the Properties menu option. The SQL Server Properties dialog box appears (see Figure 6.16). From this dialog box, you can configure server options by selecting the corresponding tab.
Figure 6.16. SQL Server Properties dialog box. |
Manage Logins
Follow these steps to manage logins:
1. | From ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
