| Author |
Message |
sux.stellino
Joined: 14 Jan 2011
Posts: 4
Location: it
|
 Posted: Fri Oct 26, 2012 11:33 am Post subject: 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:
| 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 |
|
 |
Chris Auckland
Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
|
| Posted: Tue Oct 30, 2012 2:58 pm Post subject: |
|
|
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 |
|
|
sux.stellino
Joined: 14 Jan 2011
Posts: 4
Location: it
|
| Posted: Tue Oct 30, 2012 9:24 pm Post subject: |
|
|
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 |
|
|
|
|
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
