修改sql服务器名称

if serverproperty('WIN-91QC9B4UDD1') <> @@servername
begin
    declare @server sysname
    set @server = @@servername
    exec sp_dropserver @server = @server
    set @server = cast(serverproperty('WIN-91QC9B4UDD1') as sysname)
    exec sp_addserver @server = @server , @local = 'LOCAL'
end
原文地址:https://www.cnblogs.com/sxlfybb/p/1586965.html