issue with dropping the replication


  • 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.

    26 เมษายน 2555 16:05