Start Method (SQLServer)

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 Start method starts the Microsoft SQL Server service, optionally connecting the SQLServer object on successful start.

Syntax

object.Start(StartMode, [ Server ] , [ Login ] , [ Password ] )

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • StartMode
    When TRUE, an attempt is made to connect on successful start. When FALSE, no attempt is made to connect after successful start.

  • Server
    Optional. A string that specifies an instance of SQL Server started by name.

  • Login
    Optional. A string that specifies a SQL Server login used when an attempt is made to connect after successful start (StartMode is TRUE).

  • Password
    Optional. A string that specifies a SQL Server password used for login validation when an attempt is made to connect after successful start. StartMode is TRUE.

Prototype (C/C++)

HRESULT Start(
BOOL fConnect,
SQLDMO_LPCSTR Server = NULL,
SQLDMO_LPCSTR Login = NULL,
SQLDMO_LPCSTR Password = NULL);

Remarks

The Start method can only be used on a SQLServer object not connected to an instance of SQL Server.

Specify the SQL Server service to start using the Name property of the SQLServer object, and the optional Server argument of the Start method. Using the Server argument overrides any previous specification made using the Name property.

Applies To: