How to determine if SQL DB replication is successful?
On the subscriber, open Enterprise manager for Microsoft SQL Server 7.0, expand Microsoft SQL Server. SQL Server Group, the Computer Name of the server, databases, the numerically highest database. You should see a folder entitled “Pull subscriptions”. If you click on this folder, on the right portion of the screen you will see messages indicating the success of failure of the database replication.