• You always have the option attacking this via other methods:

    1) In Windows 2000, you can set the service to restart itself (services.msc). This is the easiest approach.

    2) You can have a monitoring process that looks for SQL Server and SQL Server Agent and makes sure they are running. If they aren't, it restarts them. For instance, HealthMon, MOM, CIM (Compaq), Argent, or even a script can handle this.

    This allows you to keep these two services running without granting SQL Server Agent admin rights on the system.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley