• If you have CDC and no replication, then there's technically no 'unreplicated' transaction as it's CDC that's behind/failing, not replication. They use the same method to get transactions, that's why this looks like replication.

    As for identifying what the operation was, you could read the transaction log if you're feeling very brave. That's pretty much it unless you had something tracing commands run that you can go back through and look at (opentran gives the SPID)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass