syscomments

RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3
<< An actual SQL post for a change | Home | SQL Management Studio 2008 >>

Net Start....

The Net Start command, with no service argument, will show you the services currently running on a server.  Basically, it gives you a list of all of the services available to stop.

However, the Net Stop command, with no service argument, just gives you syntax help.  Shouldn't it give you the list of services in manual or automatic state that are currently not running?

Print | posted on Tuesday, October 21, 2008 10:15 AM |

Feedback

Gravatar

# re: Net Start....

use powershell instead :)
get-service to list the services (and use -include to filter the list)
and then stop-service and start-service to stop and start them
10/23/2008 6:00 AM | antxxxx
Gravatar

# re: Net Start....

Go read my article about DTS and SSIS. How long will powershell be around? Net Start (and, as I found later, SC) have been around awhile and work really reliably and dependably. I tend to not use new SQL Server features when equivalent functionality is available in older, proven, non-deprecated features.

Don't get me wrong, I love things like DRI and instances and the new and vastly improved workbench. But when I have to write something that's going to live on a server, I'd rather not have to re-write it in 3 years when the marketing head for the SQL Server team changes.
10/23/2008 9:01 AM | rocketscientist
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Chris Miller