SQL Service Manager?

Question

What is SQL service manager and what does it do?

Answer 1

Service Manager is used to control the MSSQLServer (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services.

kindly check the below link http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/admincmp/75517c01.mspx?mfr=true

Answer 2

This is one of the sql server utilities.

SQL Server Service Manager manages all instances of SQL Server, SQL Server Agent and MS DTC, as well as Microsoft Search and MSSQLServerOLAPService services. It provides a simple way to start, stop, or check the state of any of these services. Once you've used this application after booting the operating system, the application places an icon on the taskbar in the area of the taskbar clock.

You can right-click on this icon to retrieve a menu of all the tasks that SQL Server Service Manager supports.

Answer 3

I'm assuming Microsoft SQL here - it's a (high end) database.

I'm surprised your PC is running the Service - is it set-up as a Server ? (i.e. you have some application that is storing images or music and 'serving' this to other PC's on your network ? - or perhaps you have some 3rd party Document Management application that is creating database stores eg. mail archives ??)

I would expect a typical PC to be running MSDE (Microsoft SQL Desktop Edition) rather than the 'full blown' version ...