syntax error when deploying DBUP script through octtopus
I have DBUP scripts in the .Net Frameowrk4.5 project. For some reason when deploying the project through octopus, I get the below syntax error. This works ok on the local SQL server.
This is script
I get below error
Solution
This looks like it could be an encoding issue, is the language encoding of the embedded .sql file different than the OS language selection of the server?
- Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
- SQL Management Studio can't drag table / object from Explorer to Query Editor
- How can I put a where condition on a SqLite view statement?
- Get 2 Digit Number For The Month
- Set a column unique without being the primary key
- How to simulate a deadlock in SQL Server in a single process?
- "The big SQL RegEx": How do I RegEx split a SQL query?
- Determine column to insert into based on content
- Can a 4 column address be merged into a 2 columns address with a SELECT statement?
- How to write a "recursive update"?
- hierarchical query in Oracle
- How to Select all Columns from a Table for a Record - but to exclude a Column if all entries for that Record in said Column are null?
- Find patients admitted multiple times for the same primary diagnosis in SQL
- Updating SQL Server records with replace
- Export data from dynamic XML hierarchy in SQL Server
- How to resolve this error Ora-25137 "Data Value Out of range" in oracle
- Writing a SQL Query with multiple Where statements
- VBA - Convert a few numeric cells as text
- MySql: unknown column id in 'field list'
- SQL Server TDS protocol response problem when calling a stored procedure
- Can Postgres use the foreign key (between two tables) as the "ON" clause when LEFT JOINing them?
- Count matching value in two columns in SQL
- Why UNION and UNION ALL don't work in my code?
- Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
- PostgreSQL: Give all permissions to a user on a PostgreSQL database
- How does group by works in sequelize?
- Cursor bug when editing sql file
- Add a given value from a column based on the value from another column
- How can I make SQL case sensitive string comparison on MySQL?
- How to fix "java.sql.SQLException: Can't call commit when autocommit=true"