SQL 2012 brings us new options and cool features, one of these features is the startup parameters.
On previous versions; when we needed to update a startup parameter for the database, we needed to go to the configuration manager and then in under the SQL
server service we were able to add in a line with the startup parameter as shown here on the screenshot:
On the Startup Parameter line we had the option of adding the correct parameter.
In SQL 2012 the development team has added two new tabs to the service configuration properties:
One for the “always on” and the second for the startup parameters.
In the startup parameters we can now write down the startup parameter, click on add and it will be added to the startup parameters.
The nice thing here is that we can manage older versions of SQL from the 2012 configuration manager and enjoy this feature