Replication on SQL 2000 -- sql server replication

Big Ern
5/24/2007 12:22:00 PM

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

Hilary Cotter
5/24/2007 8:02:44 PM

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
[quoted text, click to view]

sql server replication : Replication on SQL 2000