September 4, 2009 at 7:04 am
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
This should help:
use distribution
go
declare @iPublisherDBId int
select @iPublisherDBId = d.id
from mspublisher_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
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
I got it to work thanks!
MCSE SQL Server 2012\2014\2016
September 10, 2009 at 3:22 pm
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