How to set the two digit year cutoff option (Enterprise Manager)

To set the two digit year cutoff option

1. Expand a server group.
2. Right-click a server; then click Properties.
3. Click the Server Settings tab.
4. In the When a two-digit year is entered, interpret it as a year between: box, 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.

Many client applications, such as those based on OLE Automation objects, use 2030 as the cutoff year. To make SQL Server compatible with those client applications, specify a time span of 1931-2030.