VIEW: SYS.ALL_CHANGE_PROPAGATION_SETS

Source

View Text - Preformatted

SELECT
   p.sourceid_name, p.propagation_name, p.staging_database,
   s.change_set_publisher, s.change_set_name
  FROM sys.cdc_propagations$ p, sys.cdc_propagated_sets$ s
  WHERE s.propagation_name = p.propagation_name

View Text - HTML Formatted

SELECT P.SOURCEID_NAME
, P.PROPAGATION_NAME
, P.STAGING_DATABASE
, S.CHANGE_SET_PUBLISHER
, S.CHANGE_SET_NAME
FROM SYS.CDC_PROPAGATIONS$ P
, SYS.CDC_PROPAGATED_SETS$ S
WHERE S.PROPAGATION_NAME = P.PROPAGATION_NAME