Cannot detach the database for previous publications

I had replication job in one database. Since I need to detach the database
and move it somewhere else, I deleted all publications. However when I tried
to detach the db, the error message says that the database cannot be detached
because it is replicated. I updated the statistics of both that database and
distribution database. However the error remains. Please advice.
Thanks,
Charts
Try using sp_dboption to set 'published' and 'merge publish' to false.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Great ! It works. Thanks so much.
"Paul Ibison" wrote:

> Try using sp_dboption to set 'published' and 'merge publish' to false.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>

Cannot delete merge publication

Hello...
I had a merge publication that I thought was removed...at least it does not
appear in Ent. Mgr under the list of Publications. However, in the
Replication Monitor the publication still exists. When I click on the
publication to delete or check its properties I get the mesage:
SQL Server could not retrieve information about publication 'My_Publication'
Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
MergePublications collection. If the name is a qualified name...'
I searched for that error code...but could not find anything that would help
me solve this problem.
if anyone has any ideas, it would be appreciated.
thanks
- dw
check sysmergepublications in the publications database. Do you find the
publication there?
If so you will need to delete it and the matching sysmergearticles columns.
Also delete the rows for this publication from
distribution.dbo.MSpublications
Hilary Cotter
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
"dw" <dw@.discussions.microsoft.com> wrote in message
news:85F329D5-E863-41A5-8AB3-8BB008C98EC7@.microsoft.com...
> Hello...
> I had a merge publication that I thought was removed...at least it does
not
> appear in Ent. Mgr under the list of Publications. However, in the
> Replication Monitor the publication still exists. When I click on the
> publication to delete or check its properties I get the mesage:
> SQL Server could not retrieve information about publication
'My_Publication'
> Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
> MergePublications collection. If the name is a qualified name...'
> I searched for that error code...but could not find anything that would
help
> me solve this problem.
> if anyone has any ideas, it would be appreciated.
> thanks
> - dw