Steve Jones - SSC Editor
April 13, 2021 at 12:00 am
Comments posted to this topic are about the item Preventing Trigger Execution
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
April 13, 2021 at 7:37 am
How thread-safe is this? I.e. will other sessions with updates also not fire the trigger?
April 13, 2021 at 8:50 am
Can I just say that I really, really dislike the use of Triggers? I know they have their place, but they are so often improperly documented and, as a consequence, a rich source of bugs.
April 13, 2021 at 6:24 pm
You can wrap it all in a transaction, but everyone who uses the table (and more) will be locked for the duration of your change.
Best to do it during off-peak hours.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply