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

  • Thread starter Thread starter Mo Quamar
  • Start date Start date
M

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
 
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.
 
Back
Top