A red X appears over the 'replicator monitor'

Using the 'SQL Server Enterprise Manager' before selecting 'push new
subsription' a red X appears over the 'replicator monitor'. I noted the red
cross appears over the folder 'merge agents'. If I look at the 'error
details of the merge agent' it says 'The process could not drop one or more
tables because the tables are being used by other publications.'. The thing
is, I'm not dropping any table, just trying to replicate a table between 3
databases. Why does this error happen?
Thnx for your time
Martin
Martin,
have a look at the tables on the subscriber. It is possible that you are
publishing an article to a subscriber that is itself publishing the article.
By default, replication will try to drop the tabl;e on the subscriber but
will be prevented from doing so. If the error message doesn't mention the
tablename, have a look at: http://support.microsoft.com/?id=312292
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||If Paul's suggestion does not help, it could be that the tables on the
subsciber are inadvertly makrked as replicated. IF the subscribing database
had at one time set up for replication or if the database has been restored
from another server where the database was published, this can happen.
If this is the case then you can use the steps in the following article to
resolve the problem:
PRB: You receive error 3724 when you drop a non-replicated object
http://support.microsoft.com/default.aspx?scid=KB;[LN];326352
Rand
This posting is provided "as is" with no warranties and confers no rights.