Replication Service: SQL Server 2000 replication enables sites to maintain multiple copies of data on different computers, in order to improve overall system performance, while ensuring that all the different copies are kept synchronized. DTS: By using DTS, you can build data warehouses and data marts in SQL Server by importing and transferring data from multiple heterogeneous sources interactively or automatically on a regularly scheduled basis. Analysis Services: Analysis Services provides tools for analyzing the data stored in data warehouses and data marts. Metadata services: SQL Server Meta Data Services provides a way to store and manage metadata about information systems and applications. This technology serves as a hub for data and component definitions, development and deployment models, reusable software components, and data warehousing descriptions. Reporting services: used to generate reports from the data in the database
Liked By
Write Answer
Which are the different services in SQL Server ? How do you manage them ?
Join MindStick Community
You have need login or register for voting of answers or question.
Amit Singh
28-Mar-2011DTS: By using DTS, you can build data warehouses and data marts in SQL Server by importing and transferring data from multiple heterogeneous sources interactively or automatically on a regularly scheduled basis.
Analysis Services: Analysis Services provides tools for analyzing the data stored in data warehouses and data marts.
Metadata services: SQL Server Meta Data Services provides a way to store and manage metadata about information systems and applications. This technology serves as a hub for data and component definitions, development and deployment models, reusable software components, and data warehousing descriptions.
Reporting services: used to generate reports from the data in the database