步骤:
sp_dropserver @server = '原HOSTNAME' , @droplogins = 'droplogins'
go
sp_addserver @server= '现HOSTNAME' , @local = 'local',@duplicate_ok = 'duplicate_OK'
重起MSSQL服务
select @@servername --查看更名是否成功
转载于:https://www.cnblogs.com/hangkk2008/archive/2011/10/11/2206840.html