Services used for better control on SQL Server. One program may have multiple services Entire SQL Server run using these services .we have
- SQL Server service
- SQL Server agent service
- SQL Server browser services
- SQL Server full text service
- msdtc service.
- SQL Server Service
If this service is running. Sql server will run.most important service. An other 4 service depend on this service. Db engine run under influence of sql service.
- SQL Server agent service
Entire automation process run under this service . agent service will look at scheduled time of jobs and invoke tasks automatically.
- SQL Server browser services
In production service this will be disabled due to security reasons.
- SQL Server full text service
We keep most repeated words in catalog for faster search of data from database.
- Msdtc
Microsoft distribution transaction coordinator useful for handling distributed transaction from other server