475
Chapter 19: Confi guring SQL Server
19
FIGURE 19-2
Use Management Studio’s Database Properties Options tab to confi gure the most common
database properties.Confi guring the Connection
Many of the connection-level options confi gure ANSI compatibility or specifi c connection-
performance options.Connection-level options are limited in scope. If the option is set within an interactive
session, then the setting is in force until it’s changed or the session ends. If the option
is set within a stored procedure, then the setting persists only for the life of that stored
procedure.c19.indd 475c19.indd 475 7/30/2012 5:42:47 PM7/30/2012 5:42:47 PM
http://www.it-ebooks.info