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

Possible BUG - Altering tables and ansi_warnings message

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
AlessandroAlpi
0

Comments

2 comments

Sort by
  • 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?
    Chris Auckland
    0
  • AlessandroAlpi
    I will try to send the complete DDL, but it was a release and I'm not sure to reproduce it..
    AlessandroAlpi
    0

Add comment

Please sign in to leave a comment.