Post reply

Error on Log Agent

  • September 4, 2009 at 7:04 am

    #210291

    Hey all:

    I keep getting this error when trying to replication to Server B from Server A. I am not sure how to find out what table is the issue as I am replicating over 1100 tables.

    Here's the error;

    if @@trancount > 0 rollback tran

    (Transaction sequence number: 0x0002E17D00035CAA000800000000, Command ID: 1)

    any ideas?

    MCSE SQL Server 2012\2014\2016

  • September 7, 2009 at 9:10 am

    #1050148

    This should help:

    use distribution

    go

    declare@iPublisherDBIdint

    select@iPublisherDBId = d.id

    frommspublisher_databases d

    inner join

    master..sysservers s

    on s.srvid = d.publisher_id

    where s.srvname = 'Server A'

    exec sp_browsereplcmds @publisher_database_id = @iPublisherDBId,

    @xact_seqno_start = N'0x0002E17D00035CAA0008',

    @xact_seqno_end = N'0x0002E17D00035CAA0008',

    @command_id = 1

    Mike

  • September 10, 2009 at 12:22 pm

    #1051875

    Mike,

    This is what I get, can you help me out?

    Msg 21110, Level 16, State 1, Procedure sp_browsereplcmds, Line 48

    @xact_seqno_start and @publisher_database_id must be specified if @command_id is specified.

    MCSE SQL Server 2012\2014\2016

  • September 10, 2009 at 12:54 pm

    #1051898

    I got it to work thanks!

    MCSE SQL Server 2012\2014\2016

  • September 10, 2009 at 3:22 pm

    #1052005

    Sorry for not replying sooner. Glad you've got it working.

    Mike

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply