Explain SQL Server Service Manager

Explain SQL Server Service Manager.

- It is used to start, stop, and pause SQL Server services that exist as the separate components on the server.

The service components are as follows:

1. SQL Server Service
2. SQL Server Agent Service
3. Microsoft Search Service
4. MSDTC Service
5. MSSQLServerOLAPService Service

- These components are run as a service on windows NT and 2000.

- SQL Server Service Manager separates executable programs on windows 98.

1. SQL Server Service:

- It implements the SQL server database engine.
- There is one SQL server service for each instance of SQL Server running on the computer.

2. SQL Server Agent Service:

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

3. Microsoft Search Service:

- It implements the full-text search engine.
- There is only one service, regardless of the number of SQL Server instances on the computer.
- This service executes only on windows NT and 2000.

4. MSDTC Service:

- It manages distributed transactions.
- There is only one service, regardless of the number of SQL Server instances on the computer.
- This service executes only on windows NT and 2000.

5. MSSSQLServerOIAPService Service:

- It implements SQL Server 2000 analysis services.
- There is only one service, regardless of the number of SQL Server instances on the computer.
- This service executes only on windows NT and 2000.
What is SQL Query Analyzer?
SQL Query Analyzer is a tool that are used for various purposes such as creating and executing queries.........
Define DTS service in SQL Server
DTS, Data Transformation Services is used to import and export data between heterogeneous data source.......
What is Replication in SQL Server?
Replication allows creating copies of data in separate databases along with keeping all databases........
Post your comment