Issue with SQL Source Control when adding fulltext index to an indexed view

I am having issues with using the source control. I have a view to which a fulltext index has been added. Initially, the file was saved correctly.

However, the file still shows up as modified in SQL Source Control. If I save the change, it adds another CREATE FULLTEXT INDEX statement to the file, and the file stays in the modified list. Every time I click the save button, the CREATE FULLTEXT INDEX statement gets added another time, and the file is never taken out of the modified list.

Has anybody else had this issue?
Tagged:

Answers

Sign In or Register to comment.