all groups > sql server replication > april 2004 >
You're in the

sql server replication

group:

How can I delete two subscriptions?


How can I delete two subscriptions? Xavi
4/14/2004 11:56:04 PM
sql server replication:
I made two one publications and after i deleted them but two subscriptions still remain.How Can I delete them
Re: How can I delete two subscriptions? Paul Ibison
4/15/2004 9:09:53 AM
Xavi,
it depends on the type of replication you had eg if your publication was a
Transactional one, then sp_dropsubscription will not work and you have the
delete the related row in MSreplication_subscriptions in the subscriber's
subscription database. If the subscription database is no longer involved in
replication (as a publisher or subscriber) then you can run
sp_removedbreplication 'dbname' to remove all the related system tables and
hence subscription info.
HTH,
Paul Ibison

AddThis Social Bookmark Button