Visual Studio 2019 SQL Server DB project - Failed to deploy to local test instance under VS with SQL72014 and SQL72045

Question

Visual Studio 2019 SQL Server DB project - Failed to deploy to local test instance under VS with SQL72014 and SQL72045

Phan, Huy (DSHS/OOS/TSD) 0

I've created a SSDT DB Project under VS2019 and imported a SQL Server 2016 DB. After fixing some builds errors, I was able to get the project to build. However, when I tried to start debugging (with F5), I kept getting the error "Error: SQL72014: SQL Execution error: A fatal error occurred. Incorrect syntax was encountered while $(ESCAPE_NONE( was being parsed." and also "Error: SQL72045: Script execution error". Googling didn't help much. Any help would be greatly appreciated.

0 comments

1 answer

Your answer

Answer 1

Anonymous

Hi @Phan, Huy (DSHS/OOS/TSD)

I don't know how your code looks like. I found a thread similar to yours: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/87039167-7bb6-42dc-b20e-0dabf9a3f44b/sql72014-sql-execution-error-a-fatal-error-occurred-incorrect-syntax-was-encountered-while-?forum=ssdt, maybe you can use it as a reference.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Phan, Huy (DSHS/OOS/TSD) 0 Reputation points

2023-07-06T01:15:01.2633333+00:00

The project name was abc_app so it created and executed a script called abc_app.sql and it errored out on the blank line as follows:

GO

PRINT N'Creating Procedure [dbo].[spXXX]...';

GO

<---- (When I double-clicked on the error SQL72045, it'll go to this blank line here).

create procedure spXXX

AS

....
Phan, Huy (DSHS/OOS/TSD) 0 Reputation points

2023-07-06T03:12:28.35+00:00

Just found out that if I exclude that particular stored procedure from the build then it'll get past that error so something is going on inside the stored procedure that I would need to investigate. Thanks for the initial suggestion.

Share via

Visual Studio 2019 SQL Server DB project - Failed to deploy to local test instance under VS with SQL72014 and SQL72045

1 answer

Your answer