a sp has 300+rows, returns Error SQL72045: Script execution error.

[wangrandk]

Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [integration].[AutoMerge]
@source NVARCHAR (255), @target NVARCHAR (255), @UsingIndex NVARCHAR (255)=NULL, @mode INT=1, @IncludeColumns NVARCHAR (MAX)=NULL, @ExcludeColumns NVARCHAR (MAX)=NULL, @SkipMissingSourceColumns BIT=0, @TruncateSourceAfterMerge BIT=0, @debug BIT=0
AS
BEGIN
SET NOCOUNT ON;
SET XACT_ABORT ON;
DECLARE @newline AS NCHAR (1) = char(13);
DECLARE @Identation AS NVARCHAR (32) = '';
DECLARE @SourceSchema AS sysname = isnull(parsename(@source, 2), schema_name()), @sourcetable AS sysname = parsename(@source, 1), @TargetSchema AS sysname = isnull(parsename(@target, 2), schema_name()), @TargetTable AS sysname = parsename(@target, 1), @indexid AS INT;
DECLARE @columns TABLE (
ColId INT ,
ColumnName sysname ,
TypeName sysname ,
Bytes SMALLINT);
DECLARE @MatchColumns AS TABLE (
ColId INT ,
ColumnName sysname);
DECLARE @SourceColumns TABLE (
ColumnName sysname);
DECLARE
Time elapsed 0:00:57.34
Error: The process 'sqlpackage' failed with exit code 1

[github-actions]

This issue is idle because it has been open for 14 days with no activity.

[ShubhamG25]

Could you help me how did you manage to deploy store procedure? I couldn't find any relevant document.

[dzsquared]

@ShubhamG25 - are you looking for overall documentation on deploying objects, including stored procedures, for SQL?

[ShubhamG25]

Yes please, if possible?

[ShubhamG25]

Also I need to enable CDC on the particular tables. I am getting this error Build error SQL70001: This statement is not recognized in this context