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.
| 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. |
|
|
|
|
|