How to: Configure the two-digit year cutoff Option (SQL Server Management Studio)

Use the two digit year cutoff option to specify an integer from 1753 to 9999 that represents the cutoff year for interpreting two-digit years as four-digit years.

To set the two-digit year cutoff option

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Misc server settings node.

  3. Under Two digit year support, in the When a two digit year is entered, interpret it as a year between box, type or select a value that is the ending year of the time span.

    The default time span for Microsoft SQL Server is 1950-2049, which represents a cutoff year of 2049. This means that SQL Server interprets a two-digit year of 49 as 2049, a two-digit year of 50 as 1950, and a two-digit year of 99 as 1999. To maintain backward compatibility, leave the setting at the default value.

See Also

Concepts

two digit year cutoff Option

Help and Information

Getting SQL Server 2005 Assistance