|Subject||Re: altering triggers from sp|
> The whole thing should be multiuser safe - I believe commiting allI think that disabling a trigger isn't just for that one transaction, even if you do it through execute statement, it's at db level, so while it might be ok for your current transaction to disable it, another transaction might suffer.
> changes in a single transaction should ensure that.
An alternative that might work is add a dummy field, which value you check within your trigger, if 1 execute trigger (default value), if 0, just exit trigger. So if you want calculation after bulk insert or whatever, just set field to 0.
just my � 2ct
[Non-text portions of this message have been removed]