Where to place SET values in a script for Enterprise

Applies to: 

• Liquibase Enterprise

Conditions:

• Any version of Liquibase Enterprise
• Database that has SET statements such as SQL Server

Question:

Where do I place SET statements for packager to deploy them successfully? 

Answer:

It is recommended to place the SET statements outside of the object being either created or modified in the script. 

For example, we recommend this structure:

SET QUOTED_IDENTIFIER ON;
GO
 
CREATE OR ALTER PROCEDURE .
    SELECT ...

Whereas you might have packager issues with this structure:

CREATE OR ALTER PROCEDURE .
    SET QUOTED_IDENTIFIER ON;
    SELECT ...

Related Article(s):

N/A