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.