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_session_statistics(int @session_id)MetaData:
create procedure sys.sp_MSget_session_statistics ( @session_id int ) as begin declare @agent_id int declare @retcode int -- the merge agent calls this proc select @agent_id = 0 select @agent_id = agent_id from dbo.MSmerge_sessions where session_id = @session_id -- Security Check exec @retcode = sys.sp_MScheck_pull_access @agent_id = @agent_id, @agent_type = 1 -- merge agent if @@error <> 0 or @retcode <> 0 return (1) select duration, upload_time, download_time, prepare_snapshot_time, schema_change_time, schema_changes, bulk_inserts, metadata_rows_cleanedup, estimated_upload_changes, estimated_download_changes from dbo.MSmerge_sessions with (nolock) where session_id = @session_id select phase_id, article_name, duration, inserts, updates, deletes, conflicts, rows_retried, estimated_changes from dbo.MSmerge_articlehistory with (nolock) where session_id = @session_id return 0 end
No comments:
Post a Comment