• Article

AutoStart Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The AutoStart property exposes default agent service behavior when an operating system starts.

Syntax


            object
            .AutoStart [=value]

Parts

  • object
    an expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAutoStart(LPBOOL pRetVal);
HRESULT SetAutoStart(BOOL NewValue);

Remarks

If TRUE, the service (SQL Server Agent or SQL Server) attempts to start when the operating system starts.

If FALSE, the service (SQL Server Agent or SQL Server) is not launched when the operating system starts. The agent service must be started manually.