SQL SERVER – Denali – Startup Parameters Easy to Configure

If you are regular reader of this blog, you must be aware that I have written about SQL Server Denali recently. I just finished a writing about various functions of Denali SQL SERVER – Denali – 14 New Functions – A Quick Guide. While working with Denali, at one point, I wanted to change the startup limits of the Denali. While working with Denali, I saw a very convenient method of changing the startup parameters. I just loved this clear way of changing the start up parameters.

Here is the quick way to reach to the screen where we can change the startup parameters.

Go to SQL Server Configuration Manager >> SQL Server Services >> Right Click on the Server >> Properties >> Startup Parameters

Above screen steps will bring up the startup parameter screen where one can easily change.

Any other tricks are you aware of. If yes, I welcome your comments on the same.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

One thought on “SQL SERVER – Denali – Startup Parameters Easy to Configure

  1. Pingback: SQL SERVER – Weekly Series – Memory Lane – #048 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s