• subramaniam.chandrasekar - Tuesday, February 20, 2018 4:30 AM

    http://www.dotnettricks.com/learn/sqlserver/after-trigger-instead-of-trigger-example

    I'd suggest you to go thru the above and create a test tables and triggers on your test server DB and implement. All the required objects are already present there.

    If you use INSTEAD of triggers, note that if the definition of the table changed (adding or removing columns) you will need to change the trigger as well.