ServerName Inconsistent handling

SELECT @ @SERVERNAME, serverproperty (' SERVERNAME ')

A B

The value of @ @SERVERNAME is inconsistent with the hostname of the actual host, which causes many tasks to fail

Why is not consistent, may be related to linkserver.

Repair method:

SELECT @ @SERVERNAME, serverproperty (' SERVERNAME ')

SELECT * FROM Sys.servers

exec sp_dropserver ' A '

exec sp_addserver ' B ', ' local '

After the change, you need to restart the instance to take effect, note the main standby switch here.

ServerName Inconsistent handling