sp_enumcustomresolvers (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_enumcustomresolvers(nvarchar @distributor)

MetaData:

   
--   
--  Name: sp_enumcustomresolvers  
--   
--  Descriptions:   
--   
--  Parameters: as defined in create statement  
--   
--  Returns: 0 - success  
--           1 - Otherwise  
--   
--  Security:   
--  Requires Certificate signature for catalog access  
--   
create procedure sys.sp_enumcustomresolvers  
--     @distributor parameter will be removed in the next version.        
    @distributor     sysname = NULL  
    AS  
    SET NOCOUNT ON  
  
    declare @distribution_db sysname  
    declare @distproc nvarchar(1000)  
    declare @retcode int  
    declare @regkey nvarchar(260)  
    declare @stmt     nvarchar(1000)  
  
    select @retcode = 0  
   
    --   
    --  Security Check.  
    --  Only the dbo needs to call this procedure  
     --   
    exec @retcode = sys.sp_MSreplcheck_publish  
    if @@ERROR <> 0 or @retcode <> 0  
        return(1)  
  
    --   
    --  Get the distributor   
     --   
    EXEC @retcode = sys.sp_helpdistributor @rpcsrvname = @distributor OUTPUT, @distribdb = @distribution_db OUTPUT  
    IF @@error <> 0 OR @retcode <> 0 OR @distributor IS NULL  
    BEGIN  
        RAISERROR (20036, 16, -1)  
        RETURN (1)  
    END  
  
    --   
    --  For a local distributor, query the registry directly  
     --   
              
    if LOWER(@distributor) = LOWER(@@servername) and db_name() = @distribution_db  
    begin  
  
       -- We use the temp table because we want to return article_resolver value for   
            dotnet_assembly_name column for the non-dotnet resolvers, to be consistant  
            with Yukon. In the underlying table, we just store NULL, since we will return NULL  
            for this column in sp_lookupcustomresolver  
        --   
       create table #business_logic_handlers (   
            article_resolver        nvarchar(255)   not null,   
            resolver_clsid          nvarchar(50)    not null,   
            is_dotnet_assembly      bit default 0,   
            dotnet_assembly_name    nvarchar(255)   null,   
            dotnet_class_name       nvarchar(255)   null  
        )  
  
        insert into #business_logic_handlers  
        select * from dbo.MSmerge_articleresolver  
          
        if @@ERROR<>0 return (1)          
  
        -- now update the dotnet_assembly_name for non-dotnet resolvers  
        update #business_logic_handlers  
        set  dotnet_assembly_name = article_resolver  
        where is_dotnet_assembly = 0            
  
        select * from #business_logic_handlers  
  
        drop table #business_logic_handlers  
    end  
    --    
    --  Since a downlevel publisher can connect to a remote distributor with a higher  
    --  version, it is better to return the resolver list using the RPC as opposed  
    --  to reading regkeys directly since they might change from version to version.  
     --   
    else  
    begin  
        select @distproc = quotename(RTRIM(@distributor)) + '.' + quotename(RTRIM(@distribution_db)) + '.sys.sp_enumcustomresolvers'  
        exec @distproc   
        if @@ERROR<> 0   
            return (1)  
    end  
  
    RETURN (0)