SQL remote start/stop

• • Reply

  18 years ago

  by koenwuyts

  Koen Wuyts

  Antwerp (Belgium), Belgium

  Joined 18 years ago

  Hi All,
  

  
  I have an SQL 7.0 running.
  With this code I can simply start en stop a SQL Server
  

  
  

  Code:

  
  Dim SQLServer As New SQLDMO.SQLServer
  

  
  Private Sub cmdStart_Click()
     On Error Resume Next
     SQLServer.Start False, "."
     If Err Then
         MsgBox Err.Description, vbCritical
     End If
  End Sub
  

  
  

  
  

  
  But when SQL Server Agent is running I always get an error message that other process are depending in the server, other process is SQL Server Agent.
  Now my question. How can I stop SQL Server Agent first an then the SQL Server. I don't know a way to stop SQL Server Agent. Is there a diferent DLL for that?
  

  
  rgds,
  Koen

  Report abuse