June 8, 2012

sp_script_synctran_commands (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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

Total Pageviews