Chapter 34. Configuring SQL Server

In This Chapter

  • Making sense of SQL Server configuration

  • Setting the server-level configuration options

  • Configuring the database-level configuration options

  • Configuring the connection-level options

SQL Server has a plethora of configuration options. The difficulty in mastering them lies in the fact that they are spread across three levels:

  • Server-level options generally configure how the server works with hardware, and determine the database defaults.

  • Database-level options determine the behavior of the database and set the connection-level defaults.

  • Connection-level options determine the current behaviors within the connection or current procedure.

Several of the configuration options overlap or simply set the default for the level immediately below. This chapter pulls these three configuration levels into a single unified understanding of how they relate and affect each other.

Setting the Options

Whether you choose to adjust the properties from Management Studio's graphical tool or from code is completely up to you, but not every property is available from Management Studio using the graphical interface or queries. While the graphical interface has the advantages of being easy to use and walks you through easy to understand dialogs that prompt for the possible options in a pick and choose format, it lacks the repeatability of a T-SQL script run as a query.


To view miscellaneous information about the computer system for use while configuring SQL Server, ...

Get SQL Server™ 2005 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.