I want to share with you a recent behavior of SQL Compare tool.
I tried to execute an ALTER COLUMN using SQL Compare. The statement created on the script is a simple ALTER TABLE:
- Code: Select all
ALTER TABLE myschema.mytable ALTER COLUMN myid bigint NOT NULL;
The message I receive is "ALTER TABLE failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations."
Since I knew that there are two filtered indexes I choose to find them on the created script. I noticed that on the drop section one of the two filtered index was missing. I added the drop and create statements for it and the script was excecuted successfully.
Did you experience this problem before?
Could it be a bug?