Error using 'Validation Subscription' with SPs replcations

I was runnung 'Validation Subscription' on our replication server and it try
to validate a replicated 'stored --procedure' with the row count and returned
with an error :
exec dbo.sp_table_validation @.table = 'usp_SP1', @.expected_rowcount = 0,
@.rowcount_only = 1, @.full_or_fast = 2, @.shutdown_agent = 0
Transaction sequence number and command ID of last execution batch are
0x00015D47000055A7000400000000 and 2.
Invalid object name 'usp_SP1'.
Invalid object name 'usp_SP1'.
(Source: SQLServer1\DBServer1 (Data source); Error number: 208)
Anyone may have any experience using 'Validation Subscription'? What
should be the proper step in re-syn if it returns descrapancy. I tried to run
the 'Reinitialize subscriptions having data validation failue' and it did
nothing.
Is there a system SP that can validate one Article(table) at a time? and
what whould be the proper procedure is descripancy is found?
Thanks for your help in advance.
You can't validate stored procedures - what this process does is a row count
and optionally a checksum. Stored procedures don't have rows - not even in
SQL 2005
For some people data consistency is very important and they do the row count
followed by a checksum when the row count's don't agree and if there is a
discrepancy, the agent stops so you can manually fix the problems. For
others this isn't as important and they don't have the agents stop if there
are problems. Note that if the tables are very large some people prefer the
fast rowcount option.
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
"Fas" <Fas@.discussions.microsoft.com> wrote in message
news:05E781A8-0706-4D8A-8911-34997B97D0E3@.microsoft.com...
>I was runnung 'Validation Subscription' on our replication server and it
>try
> to validate a replicated 'stored --procedure' with the row count and
> returned
> with an error :
> --
> exec dbo.sp_table_validation @.table = 'usp_SP1', @.expected_rowcount = 0,
> @.rowcount_only = 1, @.full_or_fast = 2, @.shutdown_agent = 0
> Transaction sequence number and command ID of last execution batch are
> 0x00015D47000055A7000400000000 and 2.
> Invalid object name 'usp_SP1'.
> Invalid object name 'usp_SP1'.
> (Source: SQLServer1\DBServer1 (Data source); Error number: 208)
> --
> Anyone may have any experience using 'Validation Subscription'? What
> should be the proper step in re-syn if it returns descrapancy. I tried to
> run
> the 'Reinitialize subscriptions having data validation failue' and it did
> nothing.
> Is there a system SP that can validate one Article(table) at a time? and
> what whould be the proper procedure is descripancy is found?
> Thanks for your help in advance.
>
|||Hilary,
Sorry for the confusion, I was not expected to validate SPs. I just select
Validate subscription from REplication Monitor. And it started the
validation, apparently including the SPs, which I was defined as a
replication article in the publisher. Looks like treated the SP same as
table when validating. Is there ways that I can specify just 1 table to be
validated?
Thanks for your quick response!