Tuesday, September 27, 2005

SQLServer: Issues with update triggers and bulk updates

It appears that there may be a bug with SQLServer 2000 and some update triggers.

We have a constraint update trigger on a table that verifies entries in a secondary table before allowing some fields to be updated. The trigger fires consistently when an update is done one at a time, but when a bulk update is done (refering just to many rows at once), the trigger does not consistently fire.

We'll be looking into this more, but looks like SQLServer may have reared it's ugly head again... :)