Re: 'Automating Mailing Facility'

2002-01-31 Thread Darryl Luff
I'm not sure what MS-SQL's automated mailing thing does exactly, so it depends what you want to use it for. It's easy to make a script that generates email based on the contents of the database. If you want it to generate an email when there's a server error or something, I don't think you can d

Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'

2002-01-16 Thread Darryl Luff
#x27;reject')) group by Source, Destination ; And it worked, as now the above sample becomes: Source Destination === === "s9.9.9.9" "daaa" "sbbb" "d9.9.9.9" Is this a feature or a bug? Thanks. [EMAIL PROTECTED] Darryl Luff wrot

ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'

2002-01-16 Thread Darryl Luff
Can anyone please explain what the subject error means? Full details are below. Have tried searching and not come up with anything. Thanks! Darryl Luff [EMAIL PROTECTED] When running this query: select src as Source, dst as Destination, count(*) as Drops from data where (action in ('