May 15, 2012

sp_MSget_snapshot_history (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_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

Total Pageviews