create procedure sys.sp_refresh_heterogeneous_publisher
(
    @publisher sysname
)
as
begin
    set nocount on
    declare @cmd nvarchar(4000)
                ,@retcode int
                ,@publisher_type sysname

    exec @retcode = sys.sp_MSrepl_getpublisherinfo  @publisher        = @publisher,
                                                                        @rpcheader        = @cmd OUTPUT,
                                                                        @publisher_type    = @publisher_type OUTPUT

    if @retcode <> 0
        return (@retcode)

    select @publisher = UPPER(@publisher)
            ,@cmd = @cmd + N'sys.sp_MSrepl_refresh_heterogeneous_publisher'

    exec @retcode = @cmd
                    @publisher,
                    @publisher_type

    return (@retcode)
end