I'm currently troubleshooting a replication issue and I want to identify the content of transactions that are not able to complete in a Transactional Replication topology.
Reviewing the Replication Monitor for the Distribution Agent gives me details of the relevant
Transaction Sequence Number and Command ID.
When executing sp_browsereplcmds for a specific @publisher_database_id
no records are returned for the Publisher however I know that the transactions are sourced from the given database as there is only 1 Publication DB.
When executing sp_browsereplcmds for a specific @xact_seqno_start only i.e. not additional filters, the result set has
null values for the originator_publication_db column and returns a large result set that does not allow me to isolate the specific troublesome transaction. Is this why setting a value for
@publisher_database_id returns no records?
I wonder if perhaps I am not using the system stored procedure correctly. Below is the form I am using to locate the specific transactions I am interested in however this yields no results.
@xact_seqno_start = '0x00029E5A00011092001C00000000'
,@xact_seqno_end = '0x00029E5A00011092001C00000000'
View Complete Post