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