Error 22903

Código de error: 22903, texto: “Ya hay otra conexión ejecutando ‘sp_replcmds’ para la captura de datos modificados en la base de datos actual.”

by

Recientemente me enfrenté a un escenario muy interesante en el que para una base de datos se habilitaban tanto la captura de datos modificados como la replicación transaccional. Según la documentación de MS, ambas funciones pueden funcionar juntas, pero debemos tener algunas cosas en cuenta al implementar ambas funciones juntas en una base de datos. En … Read more

Change Data Capture (CDC) with Transactional Replication

by

Continuing to previous post link, where I explained the reason of CDC capture job failure for a database enabled in transactional replication with remote distributor; here I would like to discuss the scenario of enabling change data capture for a database with local distributor. In this article we will discuss about interoperatibility of SQL server … Read more

Error code: 22903, text: ‘Another connection is already running ‘sp_replcmds’ for Change Data Capture in the current database.’.

by

Recently I faced very interesting scenario where for a database both change data capture and transactional replication was enabled. As per MS documentation, both features can work together but we need to keep few things in mind while implementing both features together on a database. Coming to my case, although change data capture job was … Read more