all groups > sql server replication > january 2007 >
You're in the

sql server replication

group:

Row Not Found Err w/ zero details


Row Not Found Err w/ zero details Chris
1/3/2007 4:43:01 PM
sql server replication:
SQL 2005 Transactional Repl. Receiving row not found error. In SQL2000 you
could view the error details and see the exact sp call sp_MSUpdxxx command
that was trying to execute w/ param values.

Now in 2005 - this is the most detail I get below: How do I see what row
was missing? tia Chris


Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0019780A0001C586015500000000, Command ID: 1)

Error messages:
The row was not found at the Subscriber when applying the replicated
command. (Source: MSSQLServer, Error number: 20598)
Get help: http://help/20598
The row was not found at the Subscriber when applying the replicated
command. (Source: MSSQLServer, Error number: 20598)
Re: Row Not Found Err w/ zero details Paul Ibison
1/4/2007 9:38:02 AM
Chris - you should be able to use sp_briowsereplcmds which takes an optional
parameter of @xact_seqno_start (and @xact_seqno_end)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

AddThis Social Bookmark Button