SQLDBA- Troubleshoot replication issue.
While encounter the error with replication. We can find which table name and which record having an issue with replication with below commands. we need to run these below commands in distribution database. -- run below command in distribution data base USE <DB name> GO SELECT TOP(10)* FROM MSrepl_errors ORDER BY TIME DESC -- Take Xact_Seqno & command _id from above resulut set and pass in below command SELECT * FROM Msrepl_commands WHERE xact_seqno = AND Command_id = We need to pass below values from above result set. EXEC SP_BROWSEREPLCMDS @xact_seqno_start = '', xact_seqno_end = '', @publisher_database_id= 1, @article_id=1, @command_id=1