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

[Mo Quamar]

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 Fallon]

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.