Replication on SQL 2000

I have a question regarding functionality with SQL 2000.
In 2005, there are several sys.dm tables that provide information regarding
the database/OS/Hardware ect... I can use these tables to check the status of
replication amoungst other things.
I know SQL 2000 does not have these tables, but was wondering if there was a
way to trap some of this information. More specifically, the status of the
distribution agent. The reason for this is that I have a 2005 box that
suscribes to a 2000 box and I can't locate any information in the sys.dm
tables regarding this subscription.
try sp_MSenum_replication_agents @.type = 3, @.exclude_anonymous = 0
If you want specific agents query
distribution.dbo.msdistribution_agent_history
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
"Big Ern" <BigErn@.discussions.microsoft.com> wrote in message
news:3C81CF85-86D6-4115-9A63-9B96B5A6A432@.microsoft.com...
>I have a question regarding functionality with SQL 2000.
> In 2005, there are several sys.dm tables that provide information
> regarding
> the database/OS/Hardware ect... I can use these tables to check the status
> of
> replication amoungst other things.
> I know SQL 2000 does not have these tables, but was wondering if there was
> a
> way to trap some of this information. More specifically, the status of the
> distribution agent. The reason for this is that I have a 2005 box that
> suscribes to a 2000 box and I can't locate any information in the sys.dm
> tables regarding this subscription.