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

kakins-tamus

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

stevehaar

I have experienced this too. It is a pain to correct.

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.