Return
-
Title
[810143] Database error 137: Must declare the scalar variable "@in" -
Description
During the schema installation step of installing a new Database the following error is shown:
'[810143] Database error 137: Must declare the scalar variable "@in"' -
Cause
The issue may be due to the compatibility mode of the database.
As per the documentation, "Compatibility level: SQL Server 2016 (130)" is required:
Using an Existing Empty SQL Server Database -
Resolution
Ensure "Compatibility level: SQL Server 2016 (130)" is set on the Database.
For more information, please refer to View or Change the Compatibility Level of a Database.