In this chapter, we'll take a look at the options for controlling how Microsoft SQL Server 2005 behaves. One main method of controlling the behavior of the SQL Server engine is to adjust configuration option settings, but you can configure that behavior in a few other ways as well. We'll look at using SQL Server Configuration Manager to control network protocols, and we'll examine the configuration options for controlling SQL Server server-wide settings. |