Sunday, April 8, 2012

Startup Parameters in SQL Server 2012

In Previous editions of SQL Server configuring Startup Parameters is night mare since missing ; means that you are not able to restart the SQL Server.

This is how you configure Startup Parameters in previous editions of SQL Server.

image

In SQL Server 2012, there is a separate tab called Startup Parameters if you navigate to service Properties dialog box.

This makes it easy to add / remove startup parameters and trace flags

image

No comments:

Post a Comment