AddStartParameter Method

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 AddStartParameter method appends a Microsoft SQL Server service startup option to those currently used by the service.



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


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

HRESULT AddStartParameter(SQLDMO_LPCSTR NewValue);

The list of SQL Server service startup options in use for an instance of SQL Server is visible in SQL Distributed Management Objects (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 noteImportant

Specifying startup options for the SQL Server service is supported for instances of SQL Server on Microsoft Windows.

Community Additions