-- ===========================
-- 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