Bug Report - SET options added to schema scripts

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

Best Answer

  • Sergio RSergio R Posts: 610 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools

Answers

Sign In or Register to comment.