Possible BUG - Altering tables and ansi_warnings message

AlessandroAlpi

Hi all,
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:

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?

Many thanks,
ale

Chris Auckland

Thanks for your post.

It sounds like a bug if it's missing a dependency and not dropping the filtered index.

Would you be able to post or PM me the complete DDL for the object so I can try and replicate the problem?

AlessandroAlpi

I will try to send the complete DDL, but it was a release and I'm not sure to reproduce it..