What are the challenges you face when working across database platforms? Take the survey

Possible BUG - Altering tables and ansi_warnings message

AlessandroAlpiAlessandroAlpi Posts: 91 Gold 2
edited October 30, 2012 4:24PM in SQL Compare Previous Versions
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,
Alessandro Alpi
CTO @ Engage IT Services s.r.l.
Database Administrator and Team Leader
Microsoft MVP - Data Platform
Staff member of getlatestversion.it community
personal website | blog


Sign In or Register to comment.