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.

• Next in forum: Re: Trigger After Delete - I need a Trigger Before Delete
• Prev in forum: Re: Ongoing purging of active records causes deadlocks
• Thread view: Re: DOS Batch File Running osql - opening/closing connections

[Reply to this message]