Msg 156, Level 15, State 1 / Incorrect syntax near the keyword 'COMPUTE'.

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'.

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 HostingDude.com upgrading databases to MS SQL 2012.

Web & Classic Hosting Help

Msg 156, Level 15, State 1 / Incorrect syntax near the keyword 'COMPUTE'.

Solution

More info

Related Articles

Msg 102, Level 15, State 1 / Incorrect syntax near '*=' or '=*'.

Msg 102, Level 15, State 1 / Incorrect syntax near 'Integer'.

Msg 195, Level 15, State 1 / 'APPEND' is not a recognized option.

Msg 321, Level 15, State 1 / "FASTFIRSTROW" is not a recognized table hints option..."

How many simultaneous connections can one MySQL database have?

Creating a Read-Only Database User

Do your hosting accounts support active or passive FTP?

Msg 102, Level 15, State 1 / Incorrect syntax near '=' or '='.