Red Gate forums :: View topic - Possible BUG - Altering tables and ansi_warnings message
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Possible BUG - Altering tables and ansi_warnings message

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sux.stellino



Joined: 14 Jan 2011
Posts: 4
Location: it

PostPosted: Fri Oct 26, 2012 11:33 am    Post subject: Possible BUG - Altering tables and ansi_warnings message Reply with quote

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:
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]
Back to top
View user's profile Send private message AIM Address MSN Messenger
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Oct 30, 2012 2:58 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
sux.stellino



Joined: 14 Jan 2011
Posts: 4
Location: it

PostPosted: Tue Oct 30, 2012 9:24 pm    Post subject: Reply with quote

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]
Back to top
View user's profile Send private message AIM Address MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group