Reputation: 1491
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
Upvotes: 0
Views: 103
Reputation: 1491
The syntax was invalid. The SQL in the windows service was obsolete.
Upvotes: 0
Reputation: 171246
According to the help topic, this syntax is just invalid and apparently never was valid for SQL Server. It looks nonsensical, too. Does it work for some other DBMS?
Upvotes: 2