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)