Viewing 8 posts - 16 through 23 (of 23 total)
An scheduled external process does a SELECT TOP n from my logging table and sends batches of e-mail.
What does this? Do you use a timed sql job, or do...
February 24, 2004 at 10:26 am
Use a table to store the message and then include that? Could us a
create table msg (spid int, mymsg varchar( 100))
Actually, that's what I'm doing, but I need...
February 23, 2004 at 11:37 am
Yes, but I need to add a footer to the message, as well as customize the subject (Attn: Mr Brown). I'm trying to generalize it so I won't have to...
February 23, 2004 at 9:45 am
Ok... you've convinced me... I was implementing a trigger that would email if certain rules were met.
I'm not saying that sending notifications to users (or running some other process) on...
February 23, 2004 at 9:31 am
This does not take into account the reliability of SQL Mail. I have had enormous amounts of trouble with SQL Mail and I highly recommend that it not be used...
February 16, 2004 at 10:01 am
A simple criteria for trigger necessity might be this: If I can get a valid report out of the database without the trigger to ensure that the data is good,...
February 12, 2004 at 10:58 am
There isn't anything the relational model can not handle for OO data storage. The only thing it can not handle is the behavior/methods/operations/pick-your-term. And by all rights it has...
February 12, 2004 at 9:06 am
A thought - you could do caching by a "last updated" table that keeps track of the table and the last time of modification. That table's timestamp column gets updated...
February 10, 2004 at 4:58 pm
Viewing 8 posts - 16 through 23 (of 23 total)