select @@servername
select serverproperty('servername')
查询不一致
执行
IF @@SERVERNAME <> SERVERPROPERTY('SERVERNAME')
BEGIN
EXEC sp_dropserver @server = @@SERVERNAME
DECLARE @new_server_name SYSNAME
SELECT @new_server_name = CAST(serverproperty('servername') as SYSNAME)
EXEC sp_addserver @server = @new_server_name , @local = 'local'
END