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