Msg 195, Level 15, State 1 / 'APPEND' is not a recognized option.
Your website might display the following error if you're using an MS SQL database:
Msg 195, Level 15, State 1, Procedure TriggerName, Line LineNumber
‘APPEND’ is not a recognized option.
‘APPEND’ is not a recognized option.
Solution
This issue occurs when you're using a WITH APPEND
clause on triggers.
To resolve the issue, recreate the trigger without using WITH APPEND
.
More info
This issue was caused by your account being upgraded to MS SQL 2012, which doesn't support WITH APPEND
. You can find more information in HostingDude.com upgrading databases to MS SQL 2012.