Microsoft® SQL Server® 2012 Bible

505

Chapter 19: Confi guring SQL Server

19

Property Level* Graphic Control Code Option

Default Full-text

Language

S Management

Studio

EXEC sp_configure

'default full-text

language'

Default Language S Management

Studio

EXEC sp_configure

'default language'

Two-Digit Year

Cutoff

S Management

Studio

EXEC sp_configure 'two

digit year cutoff'

Max Text Replication

Size

S Management

Studio

EXEC sp_configure 'max

text repl size'

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

The Advanced tab of Management Studio’s Server Properties page (see Figure 19-10) is used

to view or modify the advanced server settings.

FIGURE 19-10

Advanced tab of Management Studio’s SQL Server Properties dialog.

c19.indd 505c19.indd 505 7/30/2012 5:43:05 PM7/30/2012 5:43:05 PM

http://www.it-ebooks.info