setting up an alert

[johnjrd]

Hi

We have replication setup on our sql servers and I want to setup an alert that queries the database on both servers and tells me if the databases are out of sync by checking the number of records on a certain table.

how do i go about setting up the alert.

We are using SQL 2000 sp4

ta

 

[philhege]

I think a job would do. Query the result of substracting one recordcount from the other, and send an email if it's not zero. Understand that, depending on latency and timing, you may be alerted while replication is still occurring properly.

If you have an ongoing problem with sync issues, you should review the design of the replication scheme and the reliability of the intervening network.

Phil H.
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.