Frequently Asked Questions

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

Print this Article
Last Updated: July 15, 2015 11:49 AM

Your website might display on of the following errors if you're using an MS SQL database:

Msg 102, Level 15, State 1, Line LineNumber Incorrect syntax near '*='.
Msg 102, Level 15, State 1, Line LineNumber Incorrect syntax near '=*'.

Solution

This issue is caused by using *= or =* Transact-SQL syntax.

To resolve this issue, use ANSI join syntax instead.

More info

This issue was caused by your account being upgraded to MS SQL 2012, which doesn't support *= or =* Transact-SQL syntax. You can find more information in IX-ONE DOMAIN HOST upgrading databases to MS SQL 2012.