Triggers not firing.

[gamcall]

Hi,
I had created a whole set of triggers which controlled
the data entered into a system. I had tested them with
T-SQL statements in a test database & they seemed to work
fine. I've since dropped all of them & recreated some of
them in the test db & one in the prod database. None seem
to work anymore. They're definitely there, but there just
not "firing off" on data conditions there meant to. Any ideas?

T.I.A,
GAM [sig][/sig]

 

[TomSark]

If you are using SQL Server 7.0, make sure that they aren't disabled:

ALTER TABLE mytable ENABLE TRIGGERS ALL

Tom [sig][/sig]

 

[gamcall]

This is what I get when I try that statement:

Server: Msg 170, Level 15, State 1, Line 204
Line 204: Incorrect syntax near 'TRIGGERS'. [sig][/sig]

 

[TomSark]

crap... I'm sorry, it's ENABLE TRIGGER, not ENABLE TRIGGERS (typo on my part)...


Tom [sig][/sig]