select SERVERPROPERTY('MachineName')

in SQL 2019, select SERVERPROPERTY('MachineName') returned lower case.

in SQL 2008, returned upper case.

dos command hostname returned lower case on both server.

select @@servername returned upper case on both.

Any idea why SQL 2019 returned lower case? Any change on SERVERPROPERTY?

Thanks,

Sky