509
Chapter 19: Confi guring SQL Server
19
of 2049. If the two-digit year falls on or after the fi rst value (default 50 ), then it is inter-
preted as being in the twentieth century. If it falls on or before the second value (default
49 ), then it is interpreted as being in the twenty-fi rst century. For example, 01/01/69 is
interpreted as 01/01/1969, and 01/01/14 is interpreted as 01/01/2014.In Management Studio, you can set the two digit year cutoff confi guration option by
specifying an integer that represents the cutoff year in the Two Digit Year Cutoff box in the
Server Properties Advanced tab (refer to Figure 19-10).The following code sets the two digit year cutoff to 2041 :EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'two digit year cutoff', 2041;
RECONFIGURE;Best Practice
Use four-digit date formats to avoid ambiguity with dates.To maintain backward compatibility, leave the default setting for the two digit year cutoff con-
fi guration option.Max Text Replication Size
By default, text or image data greater than 65536 bytes (64KB) cannot be added to a rep-
licated column or captured column. The max text repl size option applies to trans-
actional replication and the Change Data Capture feature. This option does not apply to
snapshot and merge replication. The maximum size of 65536 bytes is confi gurable using the
max text repl size confi guration option.In Management Studio, you can set the max text repl size confi guration option by
specifying maximum size in the Max Text Replication Size box in the Server Properties
Advanced tab (refer to Figure 19-10).The following code sets the max text repl size to 131072 (128KB):EXEC sp_configure 'max text repl size', 131072;
RECONFIGURE;The details of replication and change data capture are discussed in Chapter 28, “Replicating Data” and
Chapter 41, “Data Change Tracking and Capture,” respectively.c19.indd 509c19.indd 509 7/30/2012 5:43:07 PM7/30/2012 5:43:07 PM
http://www.it-ebooks.info