WMI has a really easy interface to do what you are asking.

As well, it would be very easy to write a mail routine (using CDO) if
something doesn't work right, etc... To notify a help desk, etc for
quicker response to unexpected errors and minimize downtime.

WMI is rock solid. StartService StopService (code snippet at the URL
below)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/
wmi/startservice_method_in_class_win32_service.asp

Steven

> -----Original Message-----
> From: Todd Stover
> [mailto:mssqldba-ezmlmshield-x40757602.[Email address protected]
> Sent: Friday, June 30, 2006 5:41 AM
> To: LazyDBA Discussion
> Subject: automated stopping and restarting of sql services in 2000.
>
> Anyone know how to reliably do this?
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>

MS Sql Server LazyDBA home page