replication issue

Question

Hi all,

Can someone help with this issue

We have a snapshot replication that was set up on a production server
in 2010,which I believe was set up for a one time data transfer.When I
look into it now it looks to be expired and I Don't find a reason to
have it there and no one really cares about it.

When I am trying to drop the publisher it is not allowing me to do so
by returning an error

Could not delete publication 'deptdata'
Login failed for user 'db_admin'

I believe this has to do with the credentials that have been used at
the time of creating the replication.Now sure If I am right.

Can anyone let me know how to drop the replication.I have to drop some
tables as soon as possible which are being replicated which leaves me
with no other option than to drop the replication first(I believe so)

Any help is much appreciated.

Answer 1

If no other publication exist on this db then try executing sp_removedbreplication and see if that helps?

---

Brandon Williams (blog | linkedin)

Answer 2

Would there be any issues as it is the production server.

Answer 3

There should be no issues unless the database contains other publications that are needed as sp_removedbreplication will remove all replication objects from the database.

---

Brandon Williams (blog | linkedin)

Answer 4

try this

sp_droppublication deptdata, @ignore_distributor=1

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 5

Thanks for the suggestion but it errored on me

Msg 14005, Level 16, State 1, Procedure sp_MSrepl_droppublication, Line 164
Could not drop publication. A subscription exists to it.

Answer 6

huhuuuuuuuuuuuuuuuuuuuuuuuuu.

It worked.Thanks Brandon,I was just worried if it affect in any way as it is the production server.

Thank YOu so much