sp_MSget_DDL_after_regular_snapshot (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_MSget_DDL_after_regular_snapshot(nvarchar @publication)

MetaData:

 create procedure sys.sp_MSget_DDL_after_regular_snapshot (  
    @publication sysname,   
    @ddl_present bit output  
)  
as  
    declare @retcode int  
    declare @pubid uniqueidentifier  
    declare @schemaversion_of_snapshot_trailer int  
  
    exec @retcode = sys.sp_MSreplcheck_publish  
    if @retcode <> 0 or @@error <> 0  
        return 1  
  
    select @pubid = pubid from dbo.sysmergepublications    
            where name=@publication and upper(publisher)=upper(publishingservername()) and publisher_db=db_name()  
    if @pubid is NULL   
    begin  
        RAISERROR (20026, 16, -1, @publication)  
        return 1  
    end  
  
    select @schemaversion_of_snapshot_trailer = schemaversion from dbo.sysmergeschemachange   
        where pubid = @pubid and schematype = 52  
    if @schemaversion_of_snapshot_trailer is NULL  
    begin  
        raiserror(20652, 16, -1, @publication)  
        return 1  
    end  
  
    if exists (select * from dbo.sysmergeschemachange   
                where pubid = @pubid and schemaversion > @schemaversion_of_snapshot_trailer and  
                      schematype in (11, 13, 300))  
        select @ddl_present = 1  
    else  
        select @ddl_present = 0