SQL Server Performance

Checking services running from off the server - can this be done with TSQL??

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Jan 5, 2014.

  1. Trev256b Member

    Can I run a TSQL script off the SQL Server and check whether the SQL Server service and the SQL Server agent service is running? I just want to run a script to see if these two services are running on another SQL Server.
  2. Luis Martin Moderator

    xp_servicecontrol'querystate','SQLSERVERAGENT'

Share This Page