@@SERVERNAME returns hostname portion in lowercase

Question

I have a newly-built SQL 2019 instance and when I run @@SERVERNAME, the response I get is:

hostname\INSTANCENAME

where:

• hostname is in lowercase
• INSTANCENAME is in uppercase

Any ideas why this might be happening? If the instance name was lowercase, I'd put it down to me typing it that way during installation.

The Windows %COMPUTERNAME% variable returns the value in UPPERCASE.

Thanks.

Answer 1

Hi @Peter Bishop ,

This may be because %computername% returns uppercase, but not the real computer name
https://www.tenforums.com/general-support/158126-computername-returning-upper-case-name.html

you can try to find the real name using hostname or from the settings>system>about

-------------

If the answer is the right solution, please click "[Accept Answer][4]" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our [documentation][5] to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I don't know why that may be happening. What does SELECT serverproperty('ServerName') return?

Anyway, you can try this:

EXEC sp_dropserver 'lowercase\INSTANCE'
EXEC sp_addserver 'UPPERCASE\INSTANCE', 'local'

and then restart SQL Server.

Answer 3

If you prepare your server with lowercase with SQL Server 2019 Case Sensitive Instances you will start to get some error like below for Ola's MaintenanceSolution, Netbackup for Alwayson Backups, etc because this king of tools uses some SQL built-in functions. The @@SERVERNAME does not match SERVERPROPERTY('ServerName'). See https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server I think Microsoft should offer to customers to setup their servers with uppercase depending on SQL Server 2019 built-in function's returned case sensitive values anymore. UPPER Server name is best practice.