InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:24:20 GMT20http://www.sqlservercentral.com/Forums/Topic1371268-391-1.aspxThanks a lot, a SQL variant would be nice, but I am also happy, that I can use PowerShell for a serious task :)Thu, 11 Oct 2012 05:39:01 GMTArthur Kirchnerhttp://www.sqlservercentral.com/Forums/Topic1371268-391-1.aspxI have a powershell query which will list you all services running Manual Mode.Get-WMIObject -Query "Select * from Win32_Service" | Select-Object name,Startmode -- list all servicesGet-WMIObject -Query "Select * from Win32_Service Where StartMode='Manual'" | Select-Object name -- list services with manual mode startI am trying to run it from xp_cmdshell . I will get back once I get it.Thu, 11 Oct 2012 05:24:30 GMTSQL Showhttp://www.sqlservercentral.com/Forums/Topic1371268-391-1.aspxHi all,we had a "funny" disaster in the morning, because the VM was restarted and the SQL Server Service wasn't, because some joker set it to manual mode.There are intesting SP I googled like EXEC xp_servicecontrol, but what I really need is a query, that tells me the Start Type for all our servers.Thank You in advanceThu, 11 Oct 2012 02:16:33 GMTArthur Kirchner