Start Method (SQLServer)

SQL-DMO

SQL-DMO

Start Method (SQLServer)

The Start method starts the Microsoft® SQL Server™ 2000 service, optionally connecting the SQLServer object on successful start.

Applies To
SQLServer Object
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, or the optional Server argument of the Start method. Using the Server argument overrides any previous specification made using the Name property.