Sample Header Ad - 728x90

Why is SQLPackage suddenly including every scalar function in my SSDT project for ALTER in my deployment?

0 votes
1 answer
61 views
I have a SQL 2019 SSDT project with a large number of scalar and table-valued functions. Suddenly yesterday, my Windows TFS (on prem) deployment project's SQLPackage scripting step is suddenly including every scalar function in the project (~300) in the deployment script (with ALTER). I spot-checked the first dozen - in every one, the current compiled definition in the target database is identical to the definition SQLPackage intends to execute. I checked the git repo - I don't see any commits that change the project's sqlproj file. Anyone seen anything like this before?
Asked by John Hurtubise (9 rep)
Jun 10, 2024, 07:18 PM
Last activity: Jun 14, 2024, 12:12 PM