Check on Replication

i,
I have the following scenario:
One server (Publisher) is in one domain "Domain A" and the other server
(Subscriber) is in a different domain "Domain B"; the mail server is in
"Domain A" for which the subscriber is unable to send email notifications
toward any user in "Domain A".
Because of the above it's difficult for us to monitor the status of the
replication and so far we just learn that the replication is down generally
hours later it's happened.
Is there any way to check out the status of the replication from the
publisher?query the msrepl_errors table on the distribution database. If you are using
pull replication you could query the msdistribution_view to check to see if
commands are pooling. You can find this view in the distribution database.
--
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
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:37B0A8A1-FC72-443A-AC15-14A76CE3ADCD@.microsoft.com...
> i,
> I have the following scenario:
> One server (Publisher) is in one domain "Domain A" and the other server
> (Subscriber) is in a different domain "Domain B"; the mail server is in
> "Domain A" for which the subscriber is unable to send email notifications
> toward any user in "Domain A".
> Because of the above it's difficult for us to monitor the status of the
> replication and so far we just learn that the replication is down
> generally
> hours later it's happened.
> Is there any way to check out the status of the replication from the
> publisher?