Bug Report - SET options added to schema scripts

dandef

Version 6.0.2.6908.

Superfluous SET options have started being added to the schema scripts from SQL Source Control. Halfway through the section that includes indexes and constraints, the following is being added, sometimes multiple times:

SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
SET ARITHABORT ON
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET QUOTED_IDENTIFIER ON
GO

Sergio R

Hi,

We have found a bug that could cause this issue when attempting to deploy filtered indexes. This issue is now resolved in the latest version of SQL Source Control (6.2.3).

Sergio R

We are unaware of any bug regarding this on 6.0.2, if you have this issue and have a valid support and upgrades contract please contact us at support@red-gate.com so that we can troubleshoot further.

Thank you,