轻松解决启用数据库复制时出现的18483错误

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