'start', 'stop' mssqlserver

[] to start a service by calling the ServiceController.Start method

PS R:\> (Get-Service mssqlserver).Start()

MSDE7 icon at system tray turned from 'Red' to 'Green'

[] to stop a service by calling the ServiceController.Stop method

PS R:\> (Get-Service mssqlserver).Stop()

MSDE7 icon at system tray turned from 'Green' to 'Red'

stop the MSDE7 SQL server NT service

PS> stop-service -name mssqlserver -force

WARNING: Waiting for service 'MSSQLServer (MSSQLServer)' to finish stopping...

'-force' must be applied here because it has dependencies.

Others are Logical Disk Manager, COM+ Event System, Workstation, Network Connections, SSDP Discovery Service, Windows Management Instrumentation.