Triggers - Urgent -- sql server clients

Noorali Issani
4/2/2004 9:15:03 AM

I have one problem regarding activation of trigger.. basically I made one
procedure and through that procedure I am inserting data into one table
named "ALERT" and I have made trigger on Alert table on the insert event,
what that trigger is do just inserting the data into another table against
some critaria but the problem is that trigger is not activating when the
data insert through stored procedure and when I manually insert data into
Alert table then the trigger works properly, can any body give me the idea ?

Thanks in advance
NOOR

Hugo Kornelis
4/2/2004 10:29:29 AM

[quoted text, click to view]

I've never seen this behaviour. Triggers should always fire,
regardless of whether the insert/update/delete was made in a stored
procedure or in an ad-hoc query.

Can you post the DDL for the table "ALERT", the code of the trigger
and the stored procedure? Pleasu use a format that I can cut and paste
into Query Analyser to see if I can reproduce your observations.

Best, Hugo
--

sql server clients : Triggers - Urgent