Oringinally the query was running through an ado recordset object, but whilst I was trying to trap it down I ran the same query in EM and QA and it...

I apologise for my ignorance but I cannot find that type of alert.

When I create a new alert I am prompted to select a performance object and then a counter....

Just checked again and there is actually one article that is only replicated in one of the push subscriptions so I will need 2 publications.

Checking out alerts. Which counter would...

They are both transactional replications, same tables (in fact identical) just to different servers.

I have never set up an alert, what does it entail..? Looking in BOL now =).

I could...

It may well be that there are 2 push subscriptions replicating the same tables to 2 different servers.

I have set up 2 publications to the 2 different servers then a...

Thanks for the prompt reply.

The retry is set to 10 tries 1 minute apart. If I look at the subscription history it tells me it only tried 3 times..?

Further investigation...

I have had a look at the datediff function, but it doesnt quite do what I want.

At the minute I am using this query which extracts all the records with...