This statement can identify all the triggers that have the issue:

SELECT A.Object_ID, A.Definition
FROM sys.sql_modules A
INNER JOIN sys.Triggers B
 ON A.Object_ID = B.Object_ID
WHERE Definition Like '%with append%'

Maybe you could take this and create a script to update the triggers to remove the WITH APPEND clause.  If you go this route, I would recommend doing it on a test database first until you know for sure it is going to work.

Thank you Lou.

Also look at the raiserror syntax in stored procedures. The sql syntax changed in SQL 2012. 

I have a few more notes in the following blog post - https://www.rklesolutions.com/blog/running-sage-500-7-2-on-sql-server-2014/

Thank you Puttman for link to your article. We used to have Fashion Matrix Software from ISA locate din Toronto which we no longer use. Company sold out and no more support. Anyway, ISA customized PO, SO, IM, etc modules. Now 27 triggers from ISA causing problem. I am planning to comment out WITH APPEND part of trigger statements to make it work. I am not aware of RAISERROR problem. What should I look for in Sps and what should be replaced in RAISERROR syntax?  

Look for a raiserror without the parenthesis: 

SQL 2008: raiserror 55030 'text error'

SQL 2012: raiserror ('text error', 16, 1)

Cheers, 

John