Dear Friends
I have deleted the Publication from the publisher but
still the Subscription from the subscriber are not
deleted due to same i am getting error while creating new
Publication as the table can not be droped as the same
are being used by another publication.
Kindly suggest how i can delete the same so that my
replication will start working from the subscriber.
Your earlier reply would be a great help.
Best regards
Sharad
Sharad,
Running sp_removedbreplication can be used to remove all traces of
replication in the subscriber database, but obviously must only be done if
this database is not also configured as a publisher. For a more granular
approach, there is a stored procedure to do this called sp_MSunmarkreplinfo
which takes a tablename as a parameter (alternatively, setting replinfo to 0
in sysobjects for the particular table should do it).
HTH,
Paul Ibison
Sunday, March 11, 2012
Deleted Subscriptiption on Subscriber
Labels:
butstill,
database,
dear,
deleted,
due,
friendsi,
microsoft,
mysql,
notdeleted,
oracle,
publication,
publisher,
server,
sql,
subscriber,
subscription,
subscriptiption
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment