Is the Trigger enabled?

-----Original Message-----
From: Kevin Martin [mailto:kevin.[Email Address Removed]
Sent: Thursday, April 29, 2004 2:05 PM
To: LazyDBA.com Discussion
Subject: RE: Trigger not working


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%3
bst%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