issue with dropping the replication

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)

Can I try using sp_removedbreplication bit worried as it is production server...

Any help is much appreciated.

Answer 1

 sp_removedbreplication or http://msdn.microsoft.com/en-us/library/ms187808.aspx will do the job

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog