Default CREATE OR ALTER PROCEDURE

jtoussaint

Can you default CREATE OR ALTER PROCEDURE with SQL Change Automation

DanC

Hi @jtoussaint

If you're using version 4.2.20118 or higher you can go into the sqlproj file and edit it in something like NotePad++ and add the following property in the PropertyGroup section " <UseCreateOrAlterForRerunnableScripts>True</UseCreateOrAlterForRerunnableScripts>"

The following documentation explains the option: https://documentation.red-gate.com/sca/developing-databases/concepts/advanced-concepts/comparison-and-script-generation-options

Hope this helps!