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.
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.
Specifying startup options for the SQL Server service is supported for instances of SQL Server on Microsoft Windows.