Gents - the birthday is 1929 not 2029. I would prefer not to update the server because I don't now the impact.
Sorry, didn't notice the century before, looks like something's wrong there, my settings where a ran the code is
configuration_id name value minimum maximum value_in_use description is_dynamic is_advanced
1127 two digit year cutoff 2049 1753 9999 2049 two digit year cutoff 1 1
, still 7/26/29 results in 7/26/2029.
Run this code to check your settings
exec sp_configure 'show advanced options',1;RECONFIGURE;
select * from sys.configurations where name = 'two digit year cutoff';
exec sp_configure 'show advanced options',0;RECONFIGURE;
I'm being silly here, anything before the setting is interpreted as this century, anything after is last century.
You will have to assess the impact carefully before changing the settings.