{"id":17,"date":"2007-12-10T20:23:54","date_gmt":"2007-12-10T20:23:54","guid":{"rendered":"http:\/\/muratyaman.co.uk\/wp\/?p=17"},"modified":"2020-04-01T13:08:49","modified_gmt":"2020-04-01T12:08:49","slug":"m-sql-server-anomalies-2","status":"publish","type":"post","link":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/2007\/12\/m-sql-server-anomalies-2\/","title":{"rendered":"MS SQL Server: Anomalies 2"},"content":{"rendered":"<p>We had a database in MS SQL 2000 server. The server\/database was configured NOT to use <strong>recursive triggers<\/strong>. We backed up and restored the database on another machine with MS SQL 2005. Again the database is NOT using recursive triggers.<\/p>\n<p>However, our application started to behave strangely. On one of the tables, we had 2 triggers: one <strong>after insert trigger <\/strong>and one <strong>after update trigger<\/strong>. After insert trigger runs an <strong>update<\/strong> statement on the same table. This mechanism did NOT trigger the after update trigger. But apparently M$ changed SQL 2005, and it <strong>did<\/strong> execute the after update trigger.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We had a database in MS SQL 2000 server. The server\/database was configured NOT to use recursive triggers.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[56,33],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-technology","tag-ms-sql-server","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":3,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"predecessor-version":[{"id":1014,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/17\/revisions\/1014"}],"wp:attachment":[{"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muratyaman.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}