all groups > sql server replication > may 2007 >
You're in the

sql server replication

group:

SQL 2000 Transactional Replication Issue


SQL 2000 Transactional Replication Issue myrights99 NO[at]SPAM gmail.com
5/2/2007 8:34:54 AM
sql server replication: I am having issue where the data are not getting displayed on
subscriber but are on publisher. so if i run query in query analyzer
on publisher i see those records but same query run on Subscriber no
results. i see the different in database size of 300MB so if my
Publisher as 10500 then on subscriber the database size is 10200, as i
am replicating all tables/articles so i am not missing any tables in
replication. I don't have any disk space issue, nor my replication was
broken or error out or stopped working. my Log Reader & Dist agents is
working fine & none of my subscriber are expired. i am not seeing any
errors. so any lead or directions will be highly appreciated. thanking
you
Re: SQL 2000 Transactional Replication Issue Paul Ibison
5/2/2007 10:09:01 PM
What do you see if you run sp_browsereplcmds or look at the view
MSdistribution_status?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button