Microsoft® SQL Server 2012 Unleashed

Setting Configuration Options with SSMS

As mentioned previously, you can set SQL Server configuration options by using SSMS. You simply invoke SSMS from the Microsoft SQL Server program group and right-click the Server folder. In Figure 60.2, you can see the SQL Server Properties pane, the different server categories of options that are available (General, Processors, Memory, and so on), and the selected option category properties that can be adjusted. Keep in mind that some of these options are not configuration options that correspond to sp_configure (for example, the Root Directory or Platform properties of the General Server Instance properties options). However, as you will see, Microsoft has done a nice job of organizing and presenting ...