Stored procedures and triggers

[Andrew Thornberry]

Hi all,

am not sure if this is a newbie question or a real problem. I have a DELETE trigger on a table that does 'stuff'. When I delete data, the 'stuff' gets done. Then I create a stored procedure that does the delete of data - the trigger does not fire.

I have searched for text telling me that a trigger wont fire from a table updated via an SP, but cannot see that (and cannot see why you would want to do stop that).

I am trying to go down the SP and trigger path together, so assume it should work???

regards
andrew