Error code: 22903, text: ‘Another connection is already running ‘sp_replcmds’ for Change Data Capture in the current database.’.
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