What are the challenges you face when working across database platforms? Take the survey
Options

SQL Source Control keeps appending table options (SET ANSI_NULLS, etc) with every TFS check in.

kakins-tamuskakins-tamus Posts: 10 New member
edited May 2, 2018 9:36PM in SQL Source Control
With every checkin to a table, redgate is appending the following to the script that is stored in TFS.  So if I check in twice, the following will be repeated twice, and so forth:

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
Tagged:

Answers

  • Options
    stevehaarstevehaar Posts: 1 New member
    I have experienced this too. It is a pain to correct.
  • Options
    RichardLRichardL Posts: 417 Gold 4
    Hi @kakins-tamus & @stevehaar

    Thank you both for your posts. 

    This looks like something a support engineer could investigate for you so if you have a support contract with us then please send us a ticket . Add as much detail as possible to your support ticket including the version of the product you're currently on and any useful screenshots so that the team can help you faster. 

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
Sign In or Register to comment.