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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-29 : 07:57:43
|
| Fili Sosa writes "Hello,We are using SQL Server 2000 to replicate data among 2 servers. The problem is that I can not remove subscriptions from one of the servers, because we re-installed the SQL server where the publications were created. Since the publications do not exist anymore, is there a way to remove the subscriptions ??I can not delete tables from my database because a message appear telling me that it is being used for replication. So how think that by removing the subscriptions my problem can be solved. But how do I remove the subscription from the server since the publications on the distributor does not exist anymore??thanksfili sosa" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-08-04 : 07:30:50
|
| how about......removing and re-installing SQL Server on the subscription side.orre-setting up the publication to point to your subscriptionorsome sort of registry hack although i wouldn't recommend this unless you know which entries to delete====Paul |
 |
|
|
|
|
|
Removing subscriptions