Detaching replicated database

Hello there
I have database that i marked it before as publisher. Since then it showed
with hand near to it. And then i can't detach it.
I remove the publisher and it didn't help
What should i do for detach it now?
any help would be useful
Whell Paul
How can i get this book?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:27bd01c4af70$fd679b00$a301280a@.phx.gbl...
> I'm not too sure what stage the system is in - you
> mention you have removed the publisher - does this mean
> that you have disabled publishing, or removed the
> publication. I think it must be the latter. In this case
> try resetting the replication flags on the database in
> question. EG if it was Pubs:
> exec sp_dboption 'pubs','published',false
> exec sp_dboption 'pubs','merge publish',false
> After that you should be able to detack.
> HTH,
> Paul Ibison (SQL MVP)
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Oded,
I've been lucky enough to have a sort of advanced
preview, but to register for it when it comes out
publically (imminently AFAIK) have a look at this
address: http://www.nwsu.com/0974973602reg.html.
Apparently it will eventually be available on Amazon
etc. - Hilary will be able to give you more info (if he
doesn't see this thread then post a separate one in this
newsgroup FAO Hilary Cotter).
Regards,
Paul Ibison (SQL Server MVP)