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
