0

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

enter image description here

I get below error

enter image description here

Fahad Ali
  • 75
  • 1
  • 5

1 Answers1

0

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?

Twerthi
  • 36
  • 4
  • I also suspect some encoding issues. The SQL was written by another developer from a different team. I have re-written the SQL on my PC and it works this time. – Fahad Ali Feb 06 '23 at 12:40