Phantom Publications in Replication DB

Environment: SQL 2000 SP3a, Windows 2003

I had one database called RepPublisher and it had 3 transactional
replication set up based on group of articles. After that I dropped
publications on this DB and dropped the database altogether.

Here is the miracle part:
I recreated a brand new database with the same name: RepPublisher and as
soon as I enabled this database for replication, I saw the same old 3
publications which were existing at one point of time in the older database
with the same name. I ran a query againt syspublications and that table
returned no rows.

Now, How does EM sees these 3 publications from? It shows 3 red circles on
these publications with white Xs. When developers see these Xs, they think
something is wrong. Unfortunaltely, I cant figure out where are these 3
publications coming in EM. I am really getting tired of seeing them.

Any help is greatly appreciated.

Thanks in advance.
.

Relevant Pages

  • Re: Rolling Up 3 Separate Tables
    ... relationships that you are going to database. ... This Department/Organization underneath the following Department/Agency ... of linking, the real linking is record to record, and the real work of ... to look at your publications table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Comments on Merge Replication/RDA
    ... > Different publications in same database are not supported. ... > | Though not mention in SQLCE Online Books, ... > | does not support multiple subsribers in handheld. ...
    (microsoft.public.sqlserver.ce)
  • RE: Phantom Publications in Replication DB
    ... Thakns for your response. ... > The best way to delete the phantom is to 'Disable Publishing' on the box. ... > This means you'll need to delete and re-create your valid Publications. ... >> I had one database called RepPublisher and it had 3 transactional ...
    (microsoft.public.sqlserver.replication)
  • Error Icons displayed on parent objects with no or different children
    ... I recently had to restore a database from backup and the restored ... database had a different set of publications than the one I overwrote. ... I am running SqlServer 8.00.2039 SP4 Standard Edition on Windows Server ...
    (microsoft.public.sqlserver.replication)
  • RE: Phantom Publications in Replication DB
    ... This means you'll need to delete and re-create your valid Publications. ... > replication set up based on group of articles. ... > publications on this DB and dropped the database altogether. ... > I recreated a brand new database with the same name: RepPublisher and as ...
    (microsoft.public.sqlserver.replication)