Export (0) Print
Expand All

SQL Server Service Manager

SQL Server 2000

SQL Server Service Manager is used to start, stop, and pause the Microsoft® SQL Server™ 2000 components on the server. These components run as services on Microsoft Windows NT® or Microsoft Windows® 2000 and as separate executable programs on Microsoft Windows Me and Microsoft Windows 98:

  • SQL Server service

    Implements the SQL Server database engine. There is one SQL Server service for each instance of SQL Server running on the computer.

  • SQL Server Agent service

    Implements the agent that runs scheduled SQL Server administrative tasks. There is one SQL Server Agent service for each instance of SQL Server running on the computer.

  • Microsoft Search service (Windows NT and Windows 2000 only)

    Implements the full-text search engine. There is only one service, regardless of the number of SQL Server instances on the computer.

  • MSDTC service (Windows NT and Windows 2000 only)

    Manages distributed transactions. There is only one service, regardless of the number of SQL Server instances on the computer.

  • MSSQLServerOlAPService service (Windows NT and Windows 2000 only)

    Implements SQL Server 2000 Analysis Services. There is only one service, regardless of the number of SQL Server instances on the computer.

Operating the SQL Server Service Manager

SQL Server Service Manager is a taskbar application and follows the standard behavior of taskbar applications. When minimized, the SQL Server Service Manager icon appears in the area of the taskbar clock on the right of the taskbar. To get a menu that includes all the tasks SQL Server Service Manager supports, right-click the taskbar item.

To maximize SQL Server Service Manager, double-click the icon. When SQL Server Service Manager is maximized, clicking the close button of the SQL Server Service Manager window does not terminate the application; it only minimizes SQL Server Service Manager to the taskbar. To terminate SQL Server Service Manager, right-click the SQL Server Service Manager icon on the taskbar, and then select the File/Exit menu item.

See Also

Starting, Pausing, and Stopping SQL Server

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft