create procedure sys.sp_MSretrieve_publication
    @publication sysname
     
AS
declare @retcode int
         
/*
** Security Check
            
*/
exec @retcode = sys.sp_MSreplcheck_publish
if @@ERROR <> 0 or @retcode <> 0
    return(1)

select 'Name' = name,
       
        'database ' = db_name(),
        'publisher' = publishingservername(),
        'type' = case when LOWER(repl_freq)=1 then 'Snapshot' else 'Transactional' end,
         
        'description ' = description,
        'status ' = status,
        'allow known pull subscription' = allow_pull,
         
        'allow immediate-updating subscription ' = allow_sync_tran,
        'allow anonymous ' = allow_anonymous,
        'allow queued-updating subscription ' = allow_queued_tran,
        'allow snapshot files FTP downloading' = enabled_for_internet,
        'third party' = sync_method
    from syspublications
     
    where name = @publication