The current language setting is used to evaluate datetime and smalldatetime literals in the partition function. [Possibility of impact] Medium
When you create or alter a partition function, datetime and smalldatetime literals in the function are evaluated assuming US_English as the language setting.