@@servername serverproperty 不一致

参考文章: 

点击打开链接

点击打开链接

--将两者协调一致，　再重启 SQL Server 服务
if serverproperty('servername')   <>   @@servername  
begin  
	declare   @server   sysname  
	set   @server   =   @@servername   
	exec   sp_dropserver   @server   =   @server
	set   @server   =   cast(serverproperty('servername')   as   sysname)  
	exec   sp_addserver   @server   =   @server   ,   @local   =   'LOCAL'  
END

use master
go
select @@servername
select serverproperty('servername')