[SQL Server 2000] How to programmatically read Merge Agent properties

Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew