Home Dashboard Directory Help
Search

Error in sp_droppublication by bbddd


Status: 

Active


3
0
Sign in
to vote
Type: Bug
ID: 795011
Opened: 7/25/2013 10:39:36 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description


Got below error when run sp_droppublication in sql 2012

in Msg 18752, Level 16, State 1, Procedure sp_replcmds, Line 1
Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure.
Msg 18752, Level 16, State 1, Procedure sp_replcmds, Line 1
Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure.
Details
Sign in to post a comment.
Posted by Kunk on 3/10/2014 at 6:29 AM
Same behaviour here on SQL Server 2012 (11.0.3339). If there are more then 1 publication on the same DB, the error only occures when the last publication is to be dropped. So I assume the errors only happens when the log-reader process is cancelled.
But even if the error occures the publication is dropped afterwards!

Regards
Wolfgang Kunk
Sign in to post a workaround.