You can use cursor to loop through mailstatus table and execute sp_SQLNotify from every result.

like

declare @username varhcar(30)

declare c cursor local fast_forward for

select username from mailstatus Where status = 'Fail'

open c

fetch...

Thanks, very nice solution.

Thanks, it worked with linked server.

Yes, I am trying to synchronize two databases (just a couple of tables). It would be great if I could do this just with running transact sql on client.

So I...