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 only need passwrd first time

Hello
I have an applicatiuon on a pda where i can synchronize the pda with
sql server 2000
When I start the application on open the synchronize window i have to
enter a user id and password.
repl.InternetLogin = userId
repl.InternetPassword = Password
I start the synchronization and it works.
The second time i synchronize it still works even with no password.
Why is that? I have to stop the application and start it again for it
to work.
If I enetr a wrong password when I synchronize the first time, I gett e
message saying: Authentication failed on the computer running IIS
I would like to get this message all the time when I synchronize with
an incorrect password.
What can I be doing wrong.
What form of authentication are you using on your IIS Server. Is it possible
that you have a blank password for the account userID?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<jensenove@.netscape.net> wrote in message
news:1144351127.584971.98050@.t31g2000cwb.googlegro ups.com...
> Hello
> I have an applicatiuon on a pda where i can synchronize the pda with
> sql server 2000
> When I start the application on open the synchronize window i have to
> enter a user id and password.
> repl.InternetLogin = userId
> repl.InternetPassword = Password
>
> I start the synchronization and it works.
> The second time i synchronize it still works even with no password.
> Why is that? I have to stop the application and start it again for it
> to work.
> If I enetr a wrong password when I synchronize the first time, I gett e
> message saying: Authentication failed on the computer running IIS
> I would like to get this message all the time when I synchronize with
> an incorrect password.
> What can I be doing wrong.
>