Sorry, didn't notice the century before, looks like something's wrong there, my settings where a ran the code is

configuration_idnamevalueminimummaximumvalue_in_usedescriptionis_dynamicis_advanced

1127two digit year cutoff2049175399992049two digit year cutoff11

, 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;

Edit: Ouch...:blush:

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.

😎