Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error 21776

Author  Topic 

prp8396
Starting Member

1 Post

Posted - 2004-10-20 : 15:55:43
I have a lingering piece of a merge publication on a SQL 2000 box. If you drill down in Enterprise Manager:

-Replication Monitor
-Publishers
-Server
-Publication (xxx:xxx)

It's at the publication level where I have the problem. When I try to remove the publication, I get the following error:

SQL Server Enterprise Manager could not retrieve information about publication 'emmain'.

Error 21776: [SQL-DMO]The name 'emmain' was not found in the TransPublications collection. If the name is a qualified name use [] to separate various parts of the name and try again.

Any ideas?

Thanks,
Prent Patrick

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-10-20 : 22:56:09
i've learned that problems with enterprise manager can be solved through qa, try sp_droppublication, read it first in BOL...

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -