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_MSget_repl_cmds_anonymous(int @agent_id, varbinary @last_xact_seqno
, bit @no_init_sync
, tinyint @get_count
, int @compatibility_level)
MetaData:
CREATE PROCEDURE sys.sp_MSget_repl_cmds_anonymous
(
@agent_id int,
@last_xact_seqno varbinary(16),
@no_init_sync bit = 0,
@get_count tinyint = 0,
@compatibility_level int = 7000000
)
as
begin
set nocount on
declare @virtual_agent_id int -- virtual sub agent id --
,@anonymous_agent_id int -- virtual anonymous agent id --
,@retcode int
-- Note @agent_id will be overwritten later.
select @virtual_agent_id = virtual_agent_id,
@anonymous_agent_id = anonymous_agent_id
from MSdistribution_agents where
id = @agent_id
-- Return error if agent entry does not exists (being deleted).
if @virtual_agent_id is null
begin
raiserror(21072, 16, -1)
return(1)
end
-- If no init sync, use anonymous account to start immediately.
-- If first time or right after reinit, use virtual account.
-- otherwise use virtual anonymous account
if @no_init_sync = 1
select @agent_id = @anonymous_agent_id
else if @last_xact_seqno = 0x00
select @agent_id = @virtual_agent_id
else
select @agent_id = @anonymous_agent_id
--
-- Call main procedure to get commands
-- PAL security check done inside this sp
--
exec @retcode = sys.sp_MSget_repl_commands
@agent_id = @agent_id,
@last_xact_seqno = @last_xact_seqno,
@get_count = @get_count,
@compatibility_level = @compatibility_level
return @retcode
end
No comments:
Post a Comment