DACPAC StoredProc update

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  December 30, 2019 at 3:43 pm

  #3711204

  Hi,

  I am struggling to push stored proc changes to database through dacpac. If I set the build action to build it's throwing errors, the statement is not recognized in this context and build fails. If I set it to none, build succeeds and no changes are pushed to database. How to fix this?

• Andrew P

  SSCarpal Tunnel

  Points: 4649

  More actions

  December 30, 2019 at 11:46 pm

  #3711351

  Hi Dhruva_51,

  I recommend pasting the stored procedure text into SSMS, then running it (if appropriate), to verify you don't have invalid syntax.

  If you're not able to, or the query is still valid, are you able to post the block of code that it's throwing the error on?

  Andrew