O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required