修改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

posted on 2009-10-20 15:43  房客  阅读(432)  评论(0编辑  收藏  举报

导航