If you have an environment with hundreds of components running across multiple servers, then you should be running with MTS. MTS allows developers to build transactional integrity into every application, enables safe integration of components from multiple developers and development environments, enables distributed applications across multiple servers and databases, and provides a single point from which to manage the components and their security.

Looking to the future, it is COM+ and the .NET framework that is building on what has already been defined by MTS and other services. COM+ is at the heart of most .NET implementations and is the infrastructure for building enterprise applications for Microsoft. And .NET/COM+ continues to become more highly integrated with each release. And, of course, MTS is a critical player within COM+.

The next chapter, "SQL Server Full-Text Search Services," will highlight the essential services capabilities and show you how easy it is to take advantage of them from within any SQL Server application.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features