CREATE PROCEDURE sys.sp_MShelp_profilecache (
    @profile_name sysname = NULL
)
as
    declare @profile_id int
    declare @retcode int

    
    -- security check
    
    exec @retcode = sys.sp_MSreplcheck_subscribe
    if @@ERROR <> 0 or @retcode <> 0
    begin
        return(1)
    end

    select @profile_id = NULL

    select parameter_name, value
        from dbo.MSmerge_agent_parameters
        where profile_name = @profile_name