sp_publication_validation procedure doesn't seem to work properly I am trying to use sp_publication_validation stored procedure to validate that my replication setup is working correctly.  This procedure is pretty straightforward and is described here.

I am running this command:

EXEC sp_publication_validation @publication = 'MyPublication'
    ,@rowcount_only = 1     -- (1 - rowcnt only, 2 - rowcnt and checksum)
    ,@full_or_fast = 0      -- (0 - full count using COUNT(*), 1 - use sysindexes.rows, 2 - conditional)


Initially everything seems to be ok and the results indicate that all of the tables match.  Next I go over to the subscriber and manually delete a few rows from some of the tables.  I manually verify that the row counts in my tables are now different between the publisher and the subscriber.  Finally I run the sp_publication_validation procedure again and .... it says that everything is still OK.  This is wrong!  I also tried to return both rowcnt and checksum and it still doesn't detect the fact that there are differences between the publisher and subscriber.

I appreciate any ideas.

Thank you!
My explanation is that sp_publication_validation validates a Publication: set of Articles sent by Publisher and received by Subscriber. Since there were no data corruption in transit this SP does not report any errors. 

To detect differences in replicated tables use SP_TABLE_VALIDATION.


  Either returns rowcount or checksum information on a table or indexed
  view, or compares the provided rowcount or checksum information with
  the specified table or indexed view. This stored procedure is executed
  at the Publisher on the publication database and at the Subscriber on
  the subscription database.


SP_TABLE_VALIDATION on MSDN