Stop/Start SQL

[Phylum]

Any way to programmatically start and/or stop an sql server?

 

[Rick_Fla]

In your project you must add a reference to the System.ServiceProcess.Dll

Dim x As System.ServiceProcess.ServiceController

        For Each x In ServiceProcess.ServiceController.GetServices()
            If x.ServiceName = "MSSQLSERVER" Then
                If x.Status <> ServiceProcess.ServiceControllerStatus.Running Then
                    x.Stop()
                    MessageBox.Show("Service has Stopped")
                Else
                    x.Start()
                    MessageBox.Show("Service has started")
                End If
            End If
        Next

 

[Phylum]

Thnks Ill give it a shot