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_MSanonymous_status(int @agent_id, int @no_init_sync
, varbinary @last_xact_seqno)
MetaData:
CREATE PROCEDURE sys.sp_MSanonymous_status ( @agent_id int, @no_init_sync int = 0, @last_xact_seqno varbinary(16) ) as begin set nocount on declare @virtual_agent_id int -- virtual sub agent id -- declare @anonymous_agent_id int -- virtual anonymous agent id -- -- 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 still working on the first snapshot, or just finished -- the first snapshot, use virtual account. This is to cover the case -- of multiple snapshot transactions (for example, one per article) in the first -- snapshot. -- 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 for to get status -- PAL security check is done in the main proc -- exec sys.sp_MSsubscription_status @agent_id = @agent_id end
No comments:
Post a Comment