Does anyone know how to bypass a trigger on a table without disabling the trigger altogether..

I have created an update trigger on a table, and i have also written a procedure to do a bulk update on the same table, but unfortunately, i can't run the procedure, because the update trigger fires and stop me from progressing further..

is there a way for me to by pass the trigger, without disabling and enabling it altogether..

thanks

disable triger before execute Procedure and enable after by using
Alter Table TableName Enable|Disable Trigger TrigerName

Ahmed Ali
Software Developer

Thanks..