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

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

Web & Classic Hosting Help

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

Solution

More info

Related Articles

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

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

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?

Microsoft URL Rewrite Module

FileZilla Errors: "The server's certificate is unknown" & ECONNREFUSED

Importing Data From MS Access to MS SQL

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