Visual Administration Tools

A primary goal of SQL Server 2000 is to provide administrators with easy-to-use graphical administration tools. The ease with which someone can administer SQL Server 2000 is a testimony to the success of Microsoft's development efforts.

The following tools enable you to easily set up, administer, and interact with SQL Server.

SQL Server Service Manager

From the SQL Server Service Manager, you can start, stop, and pause SQL Server, SQL Server Agent, Microsoft Distributed Transaction Coordinator, and Microsoft Search (see Figure 2.6).

Figure 2.6. The SQL Server Service Manager.

TIP

What is the purpose of the Pause button ...

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.