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