Tuesday, July 19, 2016

Missing log Table for trigger and application breaks

Hi,

I had a situation in my work recently where i had a trigger ON a Account Table and whenever a account is created, modified, deleted (record inserted) i wanted to to insert into a log table for auditing , tested in stage all good worked good for weeks


we finally decided to move to production,
Moved the trigger definition but forgot to move the LOG table and Application didn't work .


created the LOG table and everything worked as expected .


No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...