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

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, and then click Properties.
   
   
3. Click the Server Settings tab.
   
   
4. 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.

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