Home Forums Programming Powershell Powershell script to capture SQL service status RE: Powershell script to capture SQL service status

  • August 28, 2013 at 6:23 am

    #1645520

    A web search using the words "Services Powershell Status" leads to the following:

    get-service -name "MSSQLServer" -Computername TargetServerName

    Which returns

    Status Name DisplayName

    ------ ---- -----------

    Running MSSQLServer SQL Server (MSSQLSERVER)

    For named instances, the format is MSSQLServer$instancename