How to see commands with Command IDs in SQL Server 2000

Below query will help in seeing the command along with command_id. This is helpful in cases where you want to skip a corrupt command in SQL Server 2000 Transactional Replication

use distribution

select

publisher_database_id,

xact_seqno, type,

article_id,

originator_id,

command_id,

partial_command,

cast(command as nvarchar(4000))

from

msrepl_commands