sp_cdc_help_change_data_capture (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_cdc_help_change_data_capture(nvarchar @source_schema
, nvarchar @source_name)

MetaData:

   
create procedure [sys].[sp_cdc_help_change_data_capture]                    
(                                                          
    @source_schema sysname = null,  
    @source_name sysname = null  
)                                                          
as  
begin  
    set nocount on  
      
    declare @retcode int,  
        @capture_cnt int  
          
    --  Verify database is currently enabled for change data capture  
    if ([sys].[fn_cdc_is_db_enabled]() != 1)  
    begin  
        declare @db_name sysname  
        set @db_name = db_name()  
        raiserror(22901, 16, -1, @db_name)  
        return 1  
    end  
      
    create table #capture_instances  
    (  
        capture_instance sysname collate database_default null,  
        object_id int null  
    )  
      
    set @source_schema = rtrim(@source_schema)  
    set @source_name   = rtrim(@source_name)  
      
    --  Get a list of potential capture instances.   
    exec @retcode = sys.sp_cdc_get_capture_instances @source_schema, @source_name  
      
    if @retcode <> 0  
    begin  
        return 1  
    end              
  
    --  Eliminate from the list any entries that the caller is not  
    --  authorized to access  
    delete from #capture_instances  
    where sys.fn_cdc_has_select_access(capture_instance) = 0  
      
    --  If there are no elements in the #capture_instances and  
    --  an explicit schema was entered, return error  
    select @capture_cnt = count(*) from #capture_instances  
      
    if (@capture_cnt = 0) and (@source_schema is not null)  
    begin  
        raiserror(22981, 16, -1)  
        return 1   
    end  
      
    --  Return information on capture instances   
    exec sys.sp_cdc_change_data_capture  
  
    return 0  
end