O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

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

Techniques for Managing SQL Server Configuration Options

You can think of configuration options as a set of rules that define how SQL Server is configured and used. Individual server instances can have different configurations, as can the databases they support, the connections made by applications, and any statements or batch programs that are executed.

Setting Configuration Options

Configuration options can be set for:

  • A specific server instance. Server options are also referred to as instance-wide options and are set by executing the sp_configure stored procedure.

  • A specific database. Database options are also referred to as database-level options and are set by executing the ALTER DATABASE statement. The database compatibility level can be set ...

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