Merge Replication Status

Hoping someone can help.
What merge system table/s will give me the current status of my merge agent
i.e. the Replication Monitor window in Enterprise Manager displays a status
of 'suceeded' etc etc - where can I source this field from within the
Replication System tables?
Any help appreciated.
this script will get you details of the last history for
the merge agent called 'DH1791628-Northwind-
NorthwindStaff-DH1791628-3'.
It will have basic error info if an error occurs.
If you want the detailed error info, you'll need to join
to the MSrepl_errors table: MSmerge_history.error_id =
MSrepl_errors.id. This table typically has several rows
so you might want to use a cursor to add the text
together.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
declare @.agent_id int
select @.agent_id = id from msmerge_agents where name
= 'DH1791628-Northwind-NorthwindStaff-DH1791628-3'
select top 1 case
when rh.runstatus = 1 then 'Start'
when rh.runstatus = 2 then 'Succeed'
when rh.runstatus = 3 then 'In progress'
when rh.runstatus = 4 then 'Idle'
when rh.runstatus = 5 then 'Retry'
when rh.runstatus = 6 then 'Fail'
end as RunStatus,
'start_time' = convert(nvarchar(12), start_time, 112) +
substring(convert(nvarchar(24), start_time, 121), 11, 13),
comments
from MSmerge_history rh
order by timestamp desc

Merge replication real-time monitoring

Hi,
So far I used merge ActiveX control to start and monitor pull merge
subscription within C# client application. Due to fact that some subscriber
machines are rather slow and publication is relatively complex (lots of join
filters etc.), I want to offload processing to distributor. Some subscribers
often report "The process is running and is waiting for a response from one of
the backend connections".
Since I cannot control offloading with ActiveX (because it starts process on
local subscriber, or I am missing something here?), I would like to
use -Offload, start agent using msdb..sp_start_job on subscriber and monitor
replication progress by directly reading distributor's
distribution..MSmerge_history.
My questions are:
- is there better approach to accomplish same goal (e.g. .NET Remoting?)
- how to get "percentage complete" (agent outputs it if -OutputVerboseLevel 2
is used, but how to get it from subscriber?)
Links with more detailed info on replication would also be nice :-)
Thanks,
Tom
for percentage complete have a look at the status event.
The replication ActiveX controls do not support the full range of properties
that the SQL DMO replication objects support. IIRC the offloadagent
parameter is ignored in the merge ActiveX control.
"Tom" <tomislav.hrvoic.rimuv.dis@.inet.hr> wrote in message
news:%23ouVBHUJEHA.2660@.TK2MSFTNGP09.phx.gbl...
> Hi,
> So far I used merge ActiveX control to start and monitor pull merge
> subscription within C# client application. Due to fact that some
subscriber
> machines are rather slow and publication is relatively complex (lots of
join
> filters etc.), I want to offload processing to distributor. Some
subscribers
> often report "The process is running and is waiting for a response from
one of
> the backend connections".
> Since I cannot control offloading with ActiveX (because it starts process
on
> local subscriber, or I am missing something here?), I would like to
> use -Offload, start agent using msdb..sp_start_job on subscriber and
monitor
> replication progress by directly reading distributor's
> distribution..MSmerge_history.
> My questions are:
> - is there better approach to accomplish same goal (e.g. .NET Remoting?)
> - how to get "percentage complete" (agent outputs it
if -OutputVerboseLevel 2
> is used, but how to get it from subscriber?)
> Links with more detailed info on replication would also be nice :-)
> Thanks,
> Tom
>
sql

merge replication error

good day everyone. this error appear in my merge replication monitor, all my
configured database replication did not work and when i check the error log
it says:
could not find the index entry for rid
'169f87801f5a4f8724ffd146921f2447f9e23a6
6200' in index page (1:316844), inde
x
id 0, database 'Database_name'
what is the possible fix on this one?anyone help mo on this please.
Pheter FloresHi Mics,
I think you better send this message to
"microsoft.public.sqlserver.replication" newsgroup.
Ekrem ?nsoy
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:509ACE87-8F03-43B5-9A56-2FCD583DFA49@.microsoft.com...
> good day everyone. this error appear in my merge replication monitor, all
> my
> configured database replication did not work and when i check the error
> log
> it says:
> could not find the index entry for rid
> '169f87801f5a4f8724ffd146921f2447f9e23a6
6200' in index page (1:316844),
> index
> id 0, database 'Database_name'
> what is the possible fix on this one?anyone help mo on this please.
>
> Pheter Flores

merge replication error

good day everyone. this error appear in my merge replication monitor, all my
configured database replication did not work and when i check the error log
it says:
could not find the index entry for rid
'169f87801f5a4f8724ffd146921f2447f9e23a66200' in index page (1:316844), index
id 0, database 'Database_name'
what is the possible fix on this one?anyone help mo on this please.
Pheter Flores
Hi Mics,
I think you better send this message to
"microsoft.public.sqlserver.replication" newsgroup.
Ekrem ?nsoy
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:509ACE87-8F03-43B5-9A56-2FCD583DFA49@.microsoft.com...
> good day everyone. this error appear in my merge replication monitor, all
> my
> configured database replication did not work and when i check the error
> log
> it says:
> could not find the index entry for rid
> '169f87801f5a4f8724ffd146921f2447f9e23a66200' in index page (1:316844),
> index
> id 0, database 'Database_name'
> what is the possible fix on this one?anyone help mo on this please.
>
> Pheter Flores

merge replication error

good day everyone. this error appear in my merge replication monitor, all my
configured database replication did not work and when i check the error log
it says:
could not find the index entry for rid
'169f87801f5a4f8724ffd146921f2447f9e23a66200' in index page (1:316844), index
id 0, database 'Database_name'
what is the possible fix on this one?anyone help mo on this please.
Pheter FloresHi Mics,
I think you better send this message to
"microsoft.public.sqlserver.replication" newsgroup.
--
Ekrem Ã?nsoy
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:509ACE87-8F03-43B5-9A56-2FCD583DFA49@.microsoft.com...
> good day everyone. this error appear in my merge replication monitor, all
> my
> configured database replication did not work and when i check the error
> log
> it says:
> could not find the index entry for rid
> '169f87801f5a4f8724ffd146921f2447f9e23a66200' in index page (1:316844),
> index
> id 0, database 'Database_name'
> what is the possible fix on this one?anyone help mo on this please.
>
> Pheter Flores