How can we help you today? How can we help you today?

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

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
kakins-tamus
0

Comments

2 comments

Sort by
  • stevehaar
    I have experienced this too. It is a pain to correct.
    stevehaar
    0
  • RichardL
    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. 
    RichardL
    0

Add comment

Please sign in to leave a comment.