sp_MSadd_dynamic_snapshot_location (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_MSadd_dynamic_snapshot_location(nvarchar @publication
, int @partition_id
, nvarchar @dynsnap_location)

MetaData:

 create procedure sys.sp_MSadd_dynamic_snapshot_location (  
            @publication sysname,   
            @partition_id int,  
            @dynsnap_location nvarchar(255))   
as  
    set nocount on  
  
    declare @retcode  int  
      
    exec @retcode = sys.sp_MSrepl_PAL_rolecheck @publication = @publication  
    if @retcode<>0 or @@ERROR<>0  
        return 1  
  
    if @partition_id is NULL or @partition_id < 0  
        return 0  
          
    if exists(select * from dbo.MSmerge_dynamic_snapshots where partition_id = @partition_id)  
    begin  
        update dbo.MSmerge_dynamic_snapshots  
        set dynamic_snapshot_location = @dynsnap_location, last_updated = getdate()  
        where partition_id = @partition_id  
        if @retcode <> 0 or @@error <> 0  
            return 1  
    end  
    else  
    begin  
        insert into dbo.MSmerge_dynamic_snapshots (partition_id, dynamic_snapshot_location, last_updated, last_started)  
        values (@partition_id, @dynsnap_location, getdate(), NULL)  
        if @retcode <> 0 or @@error <> 0  
            return 1  
    end  
  
    return 0