Replication Checking

Here is a handy tip for checking up on replication row counts.

http://www.databasejournal.com/img/ReplicationValidation.txt

Alerts can be set up to watch for error codes but note that error code 20575 is...

Is this any help?

http://www.dbforums.com/showthread.php?t=708918

Gail

Many thanks, that advice has resolved the difficulty.

It turns out the database was a restore form a published database.

Plan

?Backed up the test db

?Placed it into Simple recovery model

?Published a small...

opps sorry, I did not notice that it was 2005 forum, forgive me.

The test db subscribes to another database.

I do not know if it was ever published, it is not...

SQL 2000

😀