We had a database in MS SQL 2000 server. The server/database was configured NOT to use recursive triggers. We backed up and restored the database on another machine with MS SQL 2005. Again the database is NOT using recursive triggers.
However, our application started to behave strangely. On one of the tables, we had 2 triggers: one after insert trigger and one after update trigger. After insert trigger runs an update statement on the same table. This mechanism did NOT trigger the after update trigger. But apparently M$ changed SQL 2005, and it did execute the after update trigger.
Categories: