Are you sure that it is the trigger that is not working, or SQL Mail? I have had SQL Mail become unresponsive in the past. I usually had to restart the SQL Server service to get it working again.
Kevin Martin
Database Engineer
Multimedia Games, Inc.



-----Original Message-----
From: Jeff Gray [mailto:jeff.[Email Address Removed] Thursday, April 29, 2004 10:05 AM
To: LazyDBA.com Discussion
Subject: Trigger not working



I created a trigger that fires an email when a certain condition happens. It was working fine on Tuesday, but out of nowhere it stopped working. However when I run my test database with the trigger in it it works. Any ideas ?


Jeff Gray
IT Manager
Premier Safety & Service, Inc.
Two Industrial Park Drive
Oakdale, PA 15071
(724) 693-8699 Ext. 511



_____

HYPERLINK "http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3bst%3b&SG=sg593&RAND=44130&partner=hotbar"Upgrade Your Email - Click here!




---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.672 / Virus Database: 434 - Release Date: 4/28/2004





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.672 / Virus Database: 434 - Release Date: 4/28/2004

MS Sql Server LazyDBA home page