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

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

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