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_script_synctran_commands(nvarchar @publication, nvarchar @article
, bit @trig_only
, bit @usesqlclr)
MetaData:
create procedure sys.sp_script_synctran_commands( @publication sysname, -- publication name -- @article sysname = 'all' -- article name, all means all article -- ,@trig_only bit = 0 ,@usesqlclr bit = 0 -- if 1, certain stored proc (e.g., sys.sp_MSscriptsynctrancommands_sqlclr) needs to be signed for min-privilege use ) as begin declare @retcode int -- -- security check -- if @trig_only = 0 begin exec @retcode = sys.sp_MSreplcheck_publish if @@error <> 0 or @retcode <> 0 begin return (1) end end else begin exec @retcode = sp_MSreplcheck_pull @publication = @publication, @raise_fatal_error = 0 if @@error <> 0 or @retcode <> 0 begin return (1) end end -- -- Generate the scripts by calling internal SP -- exec @retcode = sys.sp_MSget_synctran_commands @publication = @publication, @article = @article, @command_only = 1, @trig_only = @trig_only, @usesqlclr = @usesqlclr if @retcode <> 0 or @@error <> 0 return (1) end
No comments:
Post a Comment