I have an app that I am trying to roll out database updates to using a DbUp project through Octopus Deploy. One file keeps throwing the error Incorrect syntax near '?'. The funny part is, there isn't a '?' in the file. The code itself creates a stored procedure and there is a transaction with in it including a try catch. The SQL was written with SQL Server Management Studio and the code runs fine there. I only get the error when deploying. Any ideas on how to fix this or what the problem might be?
EDIT: Error Log
SQL exception has occurred in script: 'Name_Of_Script_Here'
October 25th 2018 14:10:29
Info Script block number: 1; Block line 17;
Message: Name_Of_Procedure_HereSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '?'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean >breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, boolean breakConnection, Action1 wrapCloseInAction
User contributions licensed under CC BY-SA 3.0