How can I configure my Azure CI pipeline for a SQL Server Data Tools (SSDT) project to ignore the SQL 70001 build error and allow the pipeline to succeed even when this error is present during the build process
TFS version -> 16.131.28106.2
SSDT version -> 17.7.10.1
SQL version -> SQL Server 2019
VS version -> 17.7.4
No, SSDT does not understand/support "alters" by design. Use CREATE only. SSDT will detect existing object on target server and alter it if needed automatically. This is not a warning, this is an error, build failure. And it affects not only the object with ALTER: this object does not get included into full project model (and into dacpac) and if any other object (another SP for example) will try to execute your "broken" SP then SSDT will say "sorry, there is no such object" (unresolved reference).