sp_IH_LR_GetCacheData (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_IH_LR_GetCacheData(nvarchar @publisher)

MetaData:

   
--   
--  Name:  
--         sp_IH_LR_GetCacheData  
--   
--  Description:  
--         Retrieve meta data for Log Reader cache  
--   
--  Inputs:  
--         @publisher        == publisher name  
--   
--  Returns:  
--         Return code (1 for error, 0 for success)  
--   
--  Security:  
--         Internal  
--  Requires Certificate signature for catalog access  
--   
--  Notes:  
--         Used by heterogeneous Log Reader for Oracle publishers  
--   
  
create PROCEDURE sys.sp_IH_LR_GetCacheData  
(  
    @publisher sysname   
)  
as  
begin  
  
    DECLARE @transactional int  
  
    SET @transactional = 0  
  
    -- -- -- --  security check, db_owner  
    declare @retcode int  
    exec @retcode = sys.sp_MSreplcheck_publish  
    if @@ERROR <> 0 or @retcode <> 0  
        return(1)  
  
    --  Begin serializable transaction  
    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE  
    BEGIN TRAN  
    DECLARE @publisher_id int  
      
    --  Determine the publisher ID  
    select    @publisher_id = i.publisher_id  
    from    IHpublishers i,  
            master.dbo.sysservers s  
    where    UPPER(s.srvname collate database_default) = UPPER(@publisher) collate database_default  
      and    i.publisher_id = s.srvid  
  
    if @@error<>0  
    BEGIN  
        COMMIT TRAN  
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
        return(1)  
    END  
  
    --  Retreive the cache publisher data  
    select    i.publisher_id,  
            d.login,  
            sys.fn_repldecryptver4(d.password),  
            i.vendor,  
            CONVERT(varchar(255), i.publisher_guid),  
            CONVERT(nvarchar(24), i.flush_request_time, 121),  
            d.publisher_type  
    from    IHpublishers i,  
            master.dbo.sysservers s,  
            msdb.dbo.MSdistpublishers d  
    where    UPPER(s.srvname collate database_default) = UPPER(@publisher) collate database_default  
      and    i.publisher_id = s.srvid  
      and    UPPER(s.srvname collate database_default) = UPPER(d.name) collate database_default  
    if @@error<>0  
    BEGIN  
        COMMIT TRAN  
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
        return(1)  
    END  
      
    --  Retrieve the cache publication data  
    select    i.name,  
            i.repl_freq,  
            i.status,  
            i.sync_method,  
            i.snapshot_jobid,   
            i.enabled_for_internet,  
            i.immediate_sync_ready,  
            i.allow_queued_tran,   
            i.allow_sync_tran,  
            i.autogen_sync_procs,  
            i.snapshot_in_defaultfolder,   
            i.alt_snapshot_folder,  
            i.pre_snapshot_script,  
            i.post_snapshot_script,   
            i.compress_snapshot,  
            i.ftp_address,  
            i.ftp_port,  
            i.ftp_subdirectory,   
            i.ftp_login,  
            sys.fn_repldecryptver4(i.ftp_password),  
            i.allow_dts,  
            i.allow_anonymous,  
            i.ad_guidname,   
            i.backward_comp_level,  
            m.publisher_id,  
            m.publisher_db,  
            m.publication_type,   
            m.independent_agent,  
            m.immediate_sync,  
            m.allow_push,  
            m.allow_pull,   
            m.description,  
            m.vendor_name,  
            m.retention,  
            m.allow_subscription_copy,   
            i.pubid  
    from    IHpublications i,  
            MSpublications m  
    where    m.publisher_id = @publisher_id  
      and    i.pubid = m.publication_id  
      and    i.repl_freq = @transactional          
  
    if @@error<>0  
    BEGIN  
        COMMIT TRAN  
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
        return(1)  
    END  
  
    --  Retrieve the cache primary key data   
    select    DISTINCT ihpcn.table_id,  
            ihpcc.publishercolumn_id,  
            ihpcc.indid   
    from    IHpublisherconstraints ihpcn,  
            IHpublishercolumnconstraints ihpcc,  
            IHpublishercolumns ihpco,  
            IHarticles iha,  
            IHpublications ip  
    where    ihpcn.publisher_id                = @publisher_id  
      and    ihpcn.publisherconstraint_id    = ihpcc.publisherconstraint_id  
      and    ihpco.publishercolumn_id        = ihpcc.publishercolumn_id  
      and    ihpcn.type                = 'PRIMARYKEY'  
      and    ihpcn.table_id     = iha.table_id      
      and    iha.publication_id = ip.pubid  
      and    ip.repl_freq = @transactional  
    order by ihpcc.indid  
  
    if @@error<>0  
    BEGIN  
        COMMIT TRAN  
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
        return(1)  
    END  
  
    --  Retrieve the cache column data   
    select    i.column_id,  
            i.publishercolumn_id,  
            i.name,   
            CASE i.mapped_length  
                WHEN -1 THEN type_name(i.mapped_type) + N'(max)'  
                ELSE type_name(i.mapped_type)  
            END,  
            i.mapped_length,   
            i.mapped_prec, i.mapped_scale,  
            i.article_id,  
            c.name,  
            c.type,  
            c.length,  
            i.mapped_nullable   
    from    IHcolumns i,  
            IHpublishercolumns c,  
            MSarticles m,  
            MSpublications l,  
            IHarticles a,  
            IHpublications ip  
    where    c.publisher_id            = @publisher_id  
      and    i.article_id            = m.article_id  
      and    m.publication_id        = l.publication_id  
      and    i.article_id            = a.article_id  
      and    a.publication_id        = l.publication_id  
      and    m.publisher_id            = a.publisher_id  
      and    m.publisher_id            = l.publisher_id  
      and    i.publishercolumn_id    = c.publishercolumn_id  
      and    m.publication_id = ip.pubid  
      and    ip.repl_freq = @transactional  
    order by i.article_id, i.column_ordinal  
  
    if @@error<>0  
    BEGIN  
        COMMIT TRAN  
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
        return(1)  
    END  
  
    --  Retrieve the cache article data   
    select    a.article_id,  
            a.name,  
            a.table_id,   
            del_cmd,  
            filter,  
            filter_clause,  
            ins_cmd,  
            pre_creation_cmd,  
            a.status,  
            type,  
            upd_cmd,  
            dest_owner,  
            dest_table,   
            a.publication_id,  
            p.owner,  
            p.name,  
            a.publisher_status,  
            a.instance_id  
    from    IHarticles a,  
            IHpublishertables p,   
            MSarticles m,  
            MSpublications l,  
            IHpublications ip  
    where    a.publisher_id        = @publisher_id  
      and    a.publisher_id        = p.publisher_id  
      and    a.table_id            = p.table_id  
      and    a.publication_id    = l.publication_id  
      and    a.article_id        = m.article_id  
      and    a.publication_id    = m.publication_id  
      and    a.publisher_id        = m.publisher_id  
      and    a.publisher_id        = l.publisher_id  
      and    m.publication_id     = ip.pubid  
      and    ip.repl_freq        = @transactional  
    if @@error<>0  
    BEGIN  
        COMMIT TRAN  
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
        return(1)  
    END  
  
    COMMIT TRAN  
    SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
    return 0  
end