SQL Server Denali : Change Startup Parameter : New Feature

Leave a comment (3) Go to comments

Changing SQL Services Startup Parameters is very easy in SQL Server Denali, which was a bib problem in all previous versions as DBA’s need to very careful about Syntax (;) , while edition startup parameters.

Now in SQL Server Denali, It’s very easy no need to take care of syntax; This will be taken care automatically by SQL Server. Great feature for beginners.

How to Change Startup Parameter in SQL Server Denali

  1. Open SQL Configuration Manager
  2. Click on SQL Server Services
  3. Select the SQL Server Database Services and Right Click
  4. In Properties box edit the parameters as shown below

 SQL Server Denali : Change Startup Parameter : New Feature SQL Server Denali Startup Parameter SQL Server Denali Service Startup Parameter How to Change Startup Parameter in SQL Server Denali  SQL Server Denali : Change Startup Parameter : New Feature SQL Server Denali Startup Parameter SQL Server Denali Service Startup Parameter How to Change Startup Parameter in SQL Server Denali


where as prior to all these releases, DBA has be very careful about Syntax prior to modify any SQL Server Parameter. As any mistake can result the failure of SQL Services.

SQL Server Denali : Change Startup Parameter : New Feature SQL Server Denali Startup Parameter SQL Server Denali Service Startup Parameter How to Change Startup Parameter in SQL Server Denali

Tags : How to Change Startup Parameter in SQL Server Denali, SQL Server Denali Startup Parameter, SQL Server Denali Service Startup Parameter, SQL Server Denali New Feature,Denali New Feature

EOF - SQL Server Denali : Change Startup Parameter : New Feature, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

3 Comments.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: