PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528
This was made possible by the Scripting Guy. I have boiled it down to the answer....
Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services
Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11″...