How to view details of xact_seqno (msrepl_errors)

• ceso

  SSC-Addicted

  Points: 424

  More actions

  February 20, 2011 at 6:55 pm

  #235282

  We have transactional replication between sql to oracle that keeps failing and i would like to view the commands in xact_seqno as it only displays a set of numbers.

• ceso

  SSC-Addicted

  Points: 424

  More actions

  February 21, 2011 at 7:06 pm

  #1289666

  i solved the problem. Had to run the following command to view the command associated with xact_seqno

  Use distribution;

  Declare @PublisherDB sysname,

  @PublisherDBID int,

  @SeqNo nchar(22),

  @CommandID int

  -- Set publisher database name and values from Replication Monitor

  Set @PublisherDB = N'enter_db_name'

  Set @SeqNo = N'enter value from xact_seqno from msrepl_errors'

  Set @CommandID = 1

  -- Find the publisher database ID

  Select @PublisherDBID = id

  From dbo.MSpublisher_databases

  Where publisher_db = @PublisherDB

  -- Get the command

  Exec sp_browsereplcmds

  @xact_seqno_start = @SeqNo,

  @xact_seqno_end = @SeqNo,

  @command_id = @CommandID,

  @publisher_database_id=@PublisherDBID;