AddStartParameter Method

SQL-DMO

SQL-DMO

AddStartParameter Method

The AddStartParameter method appends a Microsoft® SQL Server™ service startup option to those currently used by the service.

Applies To
SQLServer Object
Syntax

object.AddStartParameter( str )

Parts

object

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

str

String that specifies a startup option. For more information about startup options and their effect, see Using Startup Options.

Prototype (C/C++)

HRESULT AddStartParameter(SQLDMO_LPCSTR NewValue);

Remarks

The list of SQL Server service startup options in use for an instance of SQL Server is visible in SQL-DMO through the Parameters collection of the Configuration object. To configure startup options persistently, use the Add and Remove methods of the Parameters collection.

The AddStartParameter method can be used on a disconnected SQLServer object referencing an instance of SQL Server not yet started. The Start method of the SQLServer object will then start the SQL Server service with the option specified.

Important  Specifying startup options for the SQL Server service is supported for instances of SQL Server on Microsoft® Windows NT®. Any setting is ignored when an instance of SQL Server service is installed on Microsoft Windows® 95/98.