Replication Error

Can anyone tell me how severe this error is and how to fix it? I have
received this error twice now within the month. The database seems fine and
replication continues at the next scheduled time without error.
Error: 14151, Severity: 18, State: 1
Replication-agentclassname: agent
dti000s1-Perception33-Perception33_pub-DTI000S6-6 failed. Article
'S_ReportTopic' failed data validation (rowcount and checksum)..
When this happens also get the following error as well for every table in
the database.
Error: 20574, Severity: 10, State: 1
Subscriber 'DTI000S6' subscription to article 'A_Result' in publication
'Perception33_pub' failed data validation..
This means that the following tables are out of sync - A_Result, and
S_ReportTopic.
Run a validation to do a row count and determine how badly out of sync you
are.
Are you running the continue of data consistency error profile? I would
disable this as it hides such consistency problems.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"msnews.microsoft.com" <jduncan@.tsi.jccbi.gov> wrote in message
news:eUtPrQqSFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Can anyone tell me how severe this error is and how to fix it? I have
> received this error twice now within the month. The database seems fine
and
> replication continues at the next scheduled time without error.
> Error: 14151, Severity: 18, State: 1
> Replication-agentclassname: agent
> dti000s1-Perception33-Perception33_pub-DTI000S6-6 failed. Article
> 'S_ReportTopic' failed data validation (rowcount and checksum)..
> When this happens also get the following error as well for every table in
> the database.
> Error: 20574, Severity: 10, State: 1
> Subscriber 'DTI000S6' subscription to article 'A_Result' in publication
> 'Perception33_pub' failed data validation..
>
sql