修改数据库服务器名

USE MASTER

GO

SELECT   @@SERVERNAME ;
SELECT   SERVERPROPERTY ( 'servername' )


--要修复此问题 
     --执行下面的语句,完成后重新启动SQL服务 
   
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' )