-- ===========================
-- Name:            sp_MSmerge_passDDLcmd
-- Description:      store DDL cmd text in sysmergeschemachange
-- Caller:            sp_MSmerge_alterview
--                        sp_MSmerge_altertrigger
--                        sp_MSmerge_schemaonly
-- Security:         Public interface, in resource DB
-- Returns:          0 : success
--                        1 : failure
-- Owner:           zhenl
-- ===========================
create procedure sys.sp_MSmerge_passDDLcmd(
@artid uniqueidentifier,
@pubid uniqueidentifier,
@ddlcmd nvarchar(max)
)
AS
    declare @schemaversion int, @schemaguid    uniqueidentifier, @schematype    int, @retcode int
    set @schemaversion = NULL
    select @schemaversion = schemaversion from dbo.sysmergeschemachange

    if (@schemaversion is NULL)
        set @schemaversion = 1
    else
        select @schemaversion = 1 + max(schemaversion) from dbo.sysmergeschemachange

    set @schemaguid = newid()
    set @schematype = 300 /* DDL actions */
    exec @retcode=sys.sp_MSinsertschemachange @pubid, @artid, @schemaversion, @schemaguid, @schematype, @ddlcmd
    if @@ERROR<>0 or @retcode<>0
        return 1
    return 0