MSSQLSERVER_18752

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 18752
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name REPL_INUSE
Message Text 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.

Explanation

Only one Log Reader agent or log-related procedure can connect to a database at a time.

User Action

Make sure no other logreader is running for the same publishing database, and no other active connection had previously run sp_replcmds/sp_repltrans/sp_repldone without running sp_replflush afterwards or disconnecting.