Possible BUG - Altering tables and ansi_warnings message

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Possible BUG - Altering tables and ansi_warnings message

Postby sux.stellino » Fri Oct 26, 2012 11:33 am

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:

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?

Many thanks,
ale
Alessandro Alpi
Head of Database Administration@Goldbet Sportwetten GmbH
Microsoft MVP - Most Valuable Professional
SQL Server - Systems Administrator
http://mvp.microsoft.com/profiles/Alessandro.Alpi

[MCP] [MCITP - Database Developer] [MCTS] [MCT]
sux.stellino
 
Posts: 4
Joined: Fri Jan 14, 2011 2:47 pm
Location: it

Postby Chris Auckland » Tue Oct 30, 2012 2:58 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby sux.stellino » Tue Oct 30, 2012 9:24 pm

I will try to send the complete DDL, but it was a release and I'm not sure to reproduce it..
Alessandro Alpi
Head of Database Administration@Goldbet Sportwetten GmbH
Microsoft MVP - Most Valuable Professional
SQL Server - Systems Administrator
http://mvp.microsoft.com/profiles/Alessandro.Alpi

[MCP] [MCITP - Database Developer] [MCTS] [MCT]
sux.stellino
 
Posts: 4
Joined: Fri Jan 14, 2011 2:47 pm
Location: it


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests