Support Services

The Support Services folder contains the control icons for three services: Distributed Transaction Coordinator, Full-Text Search, and SQL Mail.

Distributed Transaction Coordinator

In a multi-server environment, DTC is used to ensure transactional integrity across servers. The only configuration available from EM is to start or stop the service. Chapter 32, “Distributed Transaction Processing,” explains why and how you would use distributed transactions.

Full-Text Search

Full-Text Search uses indexes stored outside of SQL Server to provide fast searches on text data. The only configuration provided in EM is to start and stop the service.

SQL Mail

SQL Server has the ability to send and receive e-mail messages, but to do so, it ...

Get Microsoft® SQL Server™ 2000 Unleashed, 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.