26 aprilie 2012 16:27Hi 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.
26 aprilie 2012 16:44Moderator
26 aprilie 2012 18:02Would there be any issues as it is the production server.
26 aprilie 2012 18:13Moderator
26 aprilie 2012 19:46Moderator
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
30 aprilie 2012 16:29
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.
30 aprilie 2012 16:31
It worked.Thanks Brandon,I was just worried if it affect in any way as it is the production server.
Thank YOu so much
- Marcat ca răspuns de charancherry 30 aprilie 2012 16:32