Hi is it possible to run a certain SQL statement agaisnt SQL Server and ask it not to fire any triggers? Or is would it be better to disable the trigger and then reable it after ward? If so how? Thanks Ed
In the business system I'm using we have a field called NoTriggerExec. There's a
if Update(NoTriggerExec) return
statement in the beginning of all update triggers in that business system. That way we can choose in our update's if we want the trigger to fire or not, regardless of who is doing the update in question. This is particularily useful when you need to update the row being updated, and not make the trigger go into the infamous @@Nestlevel 32 ...
The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.