DeployChangesExecutionOrder is not updated in .sqlproj file

DeepakU

I have added new sql procedure into project. When I configure project and checking for changes, it is showing one sql procedure is added and .sqlproj is updated for <ItemGroup>

    <None Include="Programmable Objects\dbo\Stored Procedures\....</ItemGroup>

.sqlproj is not updated for DeployChangesExecutionOrder and it is causing of deployment of changes into multiple environments using azure pipelines.

Also, I have tried "Import and generate script" but it get hanged visual studio. 
So what are the steps I need to perform to add any store procedures?

DanC

Hi @DeepakU

Could you go into a bit more detail about the error you're getting?