数据库实例名与服务器名不一致的解决办法

--EXEC sp_addlinkedserver --   @server = 'PSHGQ'--GO--select * from sys.servers--EXEC sp_dropserver 'PSHGQ'--EXEC sp_addserver 'SUGON', local--select @@servername--select serverproperty('servername')  use [数据库]    go    select @@servername  select serverproperty('servername')  go------  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  ELSE  PRINT '实例名与主机名一致，无需修改！'