How can we help you today?

How can we help you today?

Default CREATE OR ALTER PROCEDURE

Can you default CREATE OR ALTER PROCEDURE with SQL Change Automation

jtoussaint July 17, 2020 18:40

0

Comments

1 comment

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!

DanC July 20, 2020 09:37

0

Add comment

Please sign in to leave a comment.