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_snapshot_history(int @agent_id, timestamp @timestamp
, int @rowcount)
MetaData:
create procedure sys.sp_MSget_snapshot_history
(
@agent_id int,
@timestamp timestamp,
@rowcount int = NULL
)
as
set nocount on
declare @retcode tinyint
-- Security check - If the agent is in cache then it can access
exec @retcode = sys.sp_MScheck_pull_access @agent_type = 0, @agent_id = 0, @publication_id = 0
if @@error <> 0 or @retcode <> 0
return (1)
-- Has to be executed from distribution database
if sys.fn_MSrepl_isdistdb (db_name()) != 1
begin
raiserror (21482, 16, -1, 'sp_MSget_snapshot_history', 'distribution')
return 1
end
if @rowcount is not NULL
set rowcount @rowcount
select runstatus, comments, timestamp from MSsnapshot_history where agent_id = @agent_id and timestamp > @timestamp
No comments:
Post a Comment