O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required