merge replication History monitor

use distribution

create view LastSync
as
select subscriber_name, max(start_time) as last_sync,id
from msMerge_sessions inner join msMerge_agents
   on msmerge_agents.id = msmerge_sessions.agent_id
group by subscriber_name, id



CREATE PROCEDURE Replication_History_Monitor
AS
SELECT     LastSync.subscriber_name, LastSync.last_sync,
                  distribution.dbo.MSmerge_sessions.estimated_upload_changes +
                  distribution.dbo.MSmerge_sessions.upload_inserts + distribution.dbo.MSmerge_sessions.upload_updates + distribution.dbo.MSmerge_sessions.upload_deletes + distribution.dbo.MSmerge_sessions.download_inserts
                   + distribution.dbo.MSmerge_sessions.download_updates + distribution.dbo.MSmerge_sessions.download_deletes AS actual_rows,
                  distribution.dbo.MSmerge_sessions.duration AS total_seconds,
                  distribution.dbo.MSmerge_sessions.delivery_rate, CASE (runstatus)
                  WHEN 1 THEN 'Start' WHEN 2 THEN 'Succeed' WHEN 3 THEN 'In Progress' WHEN 4 THEN 'Idle' WHEN 5 THEN 'Retry' WHEN 6 THEN 'Fail' END AS Status
FROM         distribution.dbo.MSmerge_sessions
 INNER JOIN dbo.LastSync ON dbo.LastSync.id = distribution.dbo.MSmerge_sessions.agent_id AND distribution.dbo.MSmerge_sessions.start_time = dbo.LastSync.last_sync
 ORDER BY lastsync.last_sync DESC

Start Merge Agent through command prompt

C:\Program Files\Microsoft SQL Server\100\COM>replmerg.exe -Publication [dynamic_filter_merge_new] -Publisher MS025M2k -Subscriber [000-PCSAP39\SQLEXPRESS]  -Distributor MS025M2k -PublisherDB srmsDB_025 -SubscriberDB SRMSDB_056 -OutputVerboseLevel 4 -Output C:\Temp\snapshotagent.log -SubscriberSecurityMode 0  -SubscriptionType 2 -SubscriberLogin [02502772] -SubscriberPassword [02502772] -PublisherSecurityMode 0 -Publisherlogin [02502772] -PublisherPassword [02502772] -DistributorSecurityMode 0 -distributorlogin [02502772] -distributorpassword [02502772]

How to enable replication Log reader agents for logging to output files in SQL Server

How to enable replication agents for logging to output files in SQL Server

http://support.microsoft.com/kb/312292

-Output C:\Temp\OUTPUTFILE.txt -Outputverboselevel 3