Posted by Stephen2 on 07/20/07 13:01

On Jul 20, 1:40 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
> I don't see a problem with running a polling process like this every 5
> minutes. Personally, I'd do this in SQL Agent job with a single
> Transact-SQL step and use database mail if SQL 2005 or xp_smpt_sendmail
> (http://www.sqldev.net/xp/xpsmtp.htm) if SQL 2000.
>

Thanks Dan, that would be a better way but I couldn't get either sql
mail or xp_smpt_sendmail to work. It's a bit like the blind leading
the blind here. I just need a quick & easy solution in the short term.

[Back to original message]