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