I'm trying to remove replication from my database so that I can run some update scripts on it but SQL Enterprise Manager just keeps hanging on me. I've searched the web an no-one seems to have had this problem.
Does anyone know of this problem or have they experienced it? If so, can you help?
Am I doing something wrong trying to remove the replication (deleting the publication)?
Thanks.
More than likely it is working, it can take some time to delete a publication if there is a lot of history to remove.
If you delete the publication using a store procedure, it won't lock up SQL Enterprise Manager while you do it. If it's a merge publication you do that with this command:
exec sp_dropmergepublication @.publication = <publication name>
|||Drop the subscriptions before you drop the publications. As roamingsim has pointed out it is better to do this through QA as opposed to Enterprise Manager.
No comments:
Post a Comment