delete a replicated database as publisher

Hi,
I couldn't delete a replicated db after I disabled the database as the
publisher.
any ideas?
Thanks,
You should be able to. What is the error message you are getting?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uuoQzfb4GHA.3604@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I couldn't delete a replicated db after I disabled the database as the
> publisher.
> any ideas?
> Thanks,
>
|||Thanks, Hilary.
I got error says that Db can't be dropped because is being replicated.
Thanks again
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O4T1iBd4GHA.3404@.TK2MSFTNGP04.phx.gbl...
> You should be able to. What is the error message you are getting?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uuoQzfb4GHA.3604@.TK2MSFTNGP03.phx.gbl...
>
|||Sorry,
I re-tried to disable the publisher again. It tells me that not able to
disable the publisher beacuse distribution is in use .
Thanks
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O4T1iBd4GHA.3404@.TK2MSFTNGP04.phx.gbl...
> You should be able to. What is the error message you are getting?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:uuoQzfb4GHA.3604@.TK2MSFTNGP03.phx.gbl...
>
|||sounds like it is messed up somehow. do the following
sp_replicationdboption 'problemdbname','publish','true'
GO
sp_replicationdboption 'problemdbname','merge publish','true'
GO
sp_replicationdboption 'problemdbname','publish','False'
GO
sp_replicationdboption 'problemdbname','merge publish','False'
GO
This should clear the condition.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23U%23gU3i4GHA.696@.TK2MSFTNGP06.phx.gbl...
> Thanks, Hilary.
> I got error says that Db can't be dropped because is being replicated.
> Thanks again
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O4T1iBd4GHA.3404@.TK2MSFTNGP04.phx.gbl...
>
|||Do any other servers use this server as a distributor?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"mecn" <mecn2002@.yahoo.com> wrote in message
news:Offix%23i4GHA.2264@.TK2MSFTNGP06.phx.gbl...
> Sorry,
> I re-tried to disable the publisher again. It tells me that not able to
> disable the publisher beacuse distribution is in use .
> Thanks
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O4T1iBd4GHA.3404@.TK2MSFTNGP04.phx.gbl...
>