PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528
- 2016-08-04
sql services
This was made possible by the Scripting Guy. I have boiled it down to the answer. If you want to use PowerShell to query for the log on account that normally is displayed in the services.msc service properties window: Here is the PowerShell script: $server_name = "name_of_server"; $services...
- 2016-04-20
Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services
- 2016-03-23
Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11” | Select ServiceName Additionally, this can be set to an array and worked with as such. $services = Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11” | Select ServiceName foreach($service in $services) { $service.ServiceName } $services[0].ServiceName >>...
- 2016-03-23