Month: December 2007

..contributing to IT in London since 2002..

MS SQL Server: Anomalies 2

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 …