Microsoft® SQL Server® 2012 Bible

480

Part V: Enterprise Data Management

SQL Mail XPs 0 1 0 0

transform noise words 0 1 0 0

two digit year cutoff 1753 9999 2049 2049

user connections 0 32767 0 0

user options 0 32767 0 0

xp_cmdshell 0 1 0 0

The key difference between the previous two methods to display advanced options is that the sys

.configurations catalog view displays only the confi gurations. The show advanced options confi gura-

tion not only controls the display of advanced options through sp_configure system stored procedure, but it also

controls whether these advanced options can be changed.

Start/Stop Confi guration Properties

The startup confi guration properties, described in Table 19-1, control how SQL Server and

the processes are launched.

TABLE 19-1 Start/Stop Confi guration Properties

Property Level* Graphic Control Code Option

AutoStart SQL Server S Confi guration Manager

or Services Console

AutoStart SQL Server

Agent

SConfi guration Manager

or Services Console

AutoStart MS DTC S Services Console –

Scan for startup

procs

S– EXEC sp_configure 'scan

for startup procs'

* The confi guration level refers to server, database, or connection.

Startup Parameters

You use the startup parameters with the SQL Server services. The startup parameters are

passed as parameters to the SQL Server program when the SQL Server service is started.

Although you can add startup parameters from Services console, it’s highly recommend that

you use the SQL Server Confi guration Manager, as shown in Figure 19-5. One of the main

reasons has to do with minimizing downtime. Confi guration Manager enables you to add

startup parameters with the SQL Server service still running. You can restart the service

during a maintenance window and minimize downtime. Also, Confi guration manager is the

only method for SQL Server failover clustering instance because it is a cluster-aware tool,

and services console is not.

c19.indd 480c19.indd 480 7/30/2012 5:42:49 PM7/30/2012 5:42:49 PM

http://www.it-ebooks.info