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_MSmergesubscribedb(nvarchar @value, bit @create_ddl_triggers
, smallint @whattocreate)
MetaData:
create procedure sys.sp_MSmergesubscribedb( @value sysname, @create_ddl_triggers bit = 1, @whattocreate smallint = 1 -- 1=heavyweight,2=lightweight ) AS SET NOCOUNT ON declare @retcode int -- Security Check EXEC @retcode = sys.sp_MSreplcheck_subscribe IF @@ERROR <> 0 or @retcode <> 0 RETURN(1) -- Parameter check: @value IF LOWER(@value collate SQL_Latin1_General_CP1_CS_AS) NOT IN ('true','false') BEGIN RAISERROR(14137,16,-1) RETURN(1) END IF LOWER(@value collate SQL_Latin1_General_CP1_CS_AS) = 'true' BEGIN execute @retcode = sys.sp_MScreate_mergesystables @whattocreate=@whattocreate if @@ERROR <> 0 or @retcode <> 0 return (1) if @create_ddl_triggers = 1 begin if exists (select * from dbo.sysmergearticles) begin execute @retcode= sys.sp_MSrepl_ddl_triggers @type='merge', @mode='add' if @@ERROR <> 0 or @retcode <> 0 return (1) end end END -- We assume we will do nothing about disabling a subscriber
No comments:
Post a Comment