Ignore Trigger When Updating a Table Using VB.Net Code.

I have a table MyTable created in SQl Server 2000 which
has a UPDATE trigger to update a temporary table.
I do not want UPDATE trigger to be fired when I am
updating MyTable in my VB.Net code. Is there any ways to
accomplish this?

Thanks

Joe
Sat Jul 12 14:58:05 CDT 2003

Bad idea:
I think the only way to do this is to DROP the trigger, run your code and
CREATE the trigger.
Other users on other connections then will not run the trigger either.
--
Joe Fallon




"Mo Quamar" <mquamar@cprk.com> wrote in message
news:0a0a01c3463c$75b2f3b0$a001280a@phx.gbl...
> I have a table MyTable created in SQl Server 2000 which
> has a UPDATE trigger to update a temporary table.
> I do not want UPDATE trigger to be fired when I am
> updating MyTable in my VB.Net code. Is there any ways to
> accomplish this?
>
> Thanks