[Replication] Simple replication to find an issue

Say you get a message like this:

Cannot insert duplicate key row in object 'dbo.yourtable' with unique index 'yourtable_Index'

Run this:

--run from wherever the table exists

DECLARE @publisher_database_id INT, @article_id int

SELECT @publisher_database_id = id FROM distribution.dbo.MSpublisher_databases where publisher_db = DB_NAME()

SELECT @article_id = artid FROM dbo.sysarticles WHERE dest_table = 'yourtable'

EXEC distribution..sp_browsereplcmds @publisher_database_id = @publisher_database_id, @article_id = @article_id