Trigger Fireing

[Patrik73]

Hi!
I hope that any one can help me with this problem i have. I would like to know how I can see if a Trigger have been fired after a crash when i did an Insert in a table.

//Patrik Hegenbart, Sweden

[shubhangi]

Hi!
I hope that any one can help me with this problem i have. I would like to know how I can see if a Trigger have been fired after a crash when i did an Insert in a table.

//Patrik Hegenbart, Sweden

Hi,

u can include send mail cmd after u configure sql mail on yr m/c.
yr cmd can include
EXEC master..xp_sendmail
@recipients = 'mailid',
@subject = 'Data inserted through Insert Trigger'

This is not a normal pratice as everytime trigger is fired a mail will be coming. u can use this for testing purpose.

Shubhangi

[galexyus]

Or you can create a log table and add an insert into the log to the trigger with any additional info you might need.

Hi!
I hope that any one can help me with this problem i have. I would like to know how I can see if a Trigger have been fired after a crash when i did an Insert in a table.

//Patrik Hegenbart, Sweden