Can We call aTrigger in Procedure

0 views
Skip to first unread message

MadhuKiran

unread,
Jul 25, 2005, 8:34:52 AM7/25/05
to DotNetDe...@googlegroups.com
Hello guys
Can we call a Trigger from a procedure, i have encountered
this i have a trigger on insert and i am inserting into that table
based on condition in a procedure.

Thanks in Advance
Madhu

UnquaLe

unread,
Jul 25, 2005, 8:49:07 AM7/25/05
to DotNetDe...@googlegroups.com
If u use Insert statement in your procedure.. your trigger should fire
--
* Sadece bedenler yetmez, Ruhlarida istiyorum
* Cennette köle olmaktansa... Cehennemde kral olmayi sectim.

Hal

unread,
Jul 25, 2005, 4:32:35 PM7/25/05
to DotNetDe...@googlegroups.com
Please correct me if I am wrong, but I think that the only time a
trigger wouldn't fire is during bulk copy operations (DTS or BCP). So
any insert done in your stored proc should still trigger.

Best regards,

Hal Lesesne
http://hal.lco.net
http://my.booexpress.com

MadhuKiran

unread,
Jul 26, 2005, 12:08:13 AM7/26/05
to DotNetDe...@googlegroups.com
Thank you That Sorted My Confusion

MadhuKiran

unread,
Jul 26, 2005, 12:08:35 AM7/26/05
to DotNetDe...@googlegroups.com
Reply all
Reply to author
Forward
0 new messages