Incorrect syntax near '?' with no '?' in file

-2

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_Here

System.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

c#
sql
sql-server
octopus-deploy
dbup
asked on Stack Overflow Oct 25, 2018 by Dave Hess • edited Oct 25, 2018 by marc_s

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0