Search code examples
sql-servert-sqlsql-server-2008r2-express

What SQL syntax is this?

Can anyone tell me what SQL syntax this is please where 123 is the argument passed to the SP?

EXECUTE sp_MyStoredProcedure = '123'

When executing this command the error message from MSSMS is

102, Level 15, State 1, Line 6
syntax near '='.

We need to configure the DB (SQL Server 2008 Express) to accept SQL of this syntax as it is generated by a windows service that we can't change. Trying to set the DB compatibility doesn't work...

ALTER DATABASE ABC SET Compatibility_Level = 80 / 90 / 100
EXECUTE sp_dbcmptlevel 'ABC', 80   --80,90, 100

Thanks in advance

Solution

  • The syntax was invalid. The SQL in the windows service was obsolete.