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
 Transact-SQL (2000)
 How To Delete A Replication Database...

Author  Topic 

sdiwi
Starting Member

27 Posts

Posted - 2006-01-30 : 09:26:57
hi.

i'm having another problem:
some months ago, i created a replication database. it fetched data from the intranet and made them accessible via a subscription-db on the internet db-server. quite soon i decided, that replication was not the best way to solve my problem, so i opened the intranet-db to our internet-server.

now i want to delete my subscription-db, but i can't. the database is "in use", and i cannot delete the two tables MSsubscription_agents and MSsubscription_properties (empty system tables).

I think someone tried to delete the subscription in a "bad" way, and messed things up a bit. now the database refuses to be deleted by enterprise manages (no subscriptions, no publishers at all).

does anyone know how to "hack-"delete a subscriptiond database?

thanks,

peace,

sdiwi.
   

- Advertisement -