Msg 156, Level 15, State 1 / Incorrect syntax near the keyword 'COMPUTE'.
Print this Article
Last Updated:
July 15, 2015 11:49 AM
Your website might display the following error if you're using an MS SQL database:
Msg 156, Level 15, State 1, Line LineNumber
Incorrect syntax near the keyword 'COMPUTE'.
Incorrect syntax near the keyword 'COMPUTE'.
Solution
This issue is caused by using COMPUTE or COMPUTE BY.
To resolve this issue, use ROLLUP instead.
More info
This issue was caused by your account being upgraded to MS SQL 2012, which doesn't support COMPUTE and COMPUTE BY. You can find more information in IX-ONE DOMAIN HOST upgrading databases to MS SQL 2012.
