sql server replication: Hi

repl distribution job is running fine but job is not updating.when i click
refreshjob not showing any thing

if i stop it then it will show cancelled in history but when i run it it
will run but shows nothing in history.

please give some ideas

Thanks

--
Message posted via SQLMonster.com

You should be getting the correct data, issue this query to see if there are
pooled commands

select * from distribution.dbo.msdistribution_status

do you have a large number of undelivered commands?

--
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



[quoted text, click to view]