DECLARE @sn sysname,@sno sysname;
SELECT @sn=cast(serverproperty('servername') as sysname),@sno=@@SERVERNAME;
EXEC sp_dropserver @server = @sn
EXEC sp_addserver @server = @sno, @local = 'LOCAL'
------------------------------------------------------
--查看计算机名
SELECT @@servername AS 旧服务器名
SELECT serverproperty('servername') AS 新服务器名