SQL Server Home
2008 RTM, SSMS/Engine: Table designer doesn't script WHERE clause in filtered indexes
8/20/2008 2:28:04 PM
User(s) can reproduce this bug
When using the table designer to make changes to a table that would cause a recreate, the script will not include the WHERE clause portion of a filtered index.
SQL Server 2008 - Enterprise Edition
Tools (SSMS, Agent, Profiler, etc.)
Windows Vista SP1
Operating System Language
Steps to Reproduce
-Create a table.
-Add a filtered index to the table.
-Open the table with the designer.
-Make a change to the table that would cause a recreate (changing a column type, adding a column in the middle of the table, etc.)
-Generate the script for the change.
Script generated will not include the WHERE clause of the filtered index.
Script should include the WHERE clause. Causes headaches for tables that are using those filtered indexes to enforce conditional uniqueness! :)
to post a comment.
Please enter a comment.
on 8/5/2011 at 3:47 AM
Thanks for reporting this issue. This issue has been fixed in internal builds and will be available in an upcoming release of SQL Server "Denali".
SQL Server Manageability Team
on 3/29/2011 at 1:19 AM
Greetings from the Microsoft SQL Server Manageability Team.
We triaged this bug along with several others that had come in. Unfortunately, given our schedule and
resources, we regret to tell you that, we will not be able to fix this issue in the near future.
Thanks much for writing into Microsoft.
SQL Server Manageability
on 6/30/2009 at 11:07 AM
Thanks for your feedback, we are aware of this issue and will fix this in our future release.
on 9/29/2008 at 10:14 AM
I did search first, but this problem seemed to be specific to the table designer. Scripting through <table>->Indexes-><index>-><context menu>-CREATE TO scripts the WHERE clause just fine. My scripting option has been set to 2008 at all times. This bug is still present in RTM.
on 8/20/2008 at 3:29 PM
This is a duplicate of #357475; did you search first? Make sure that Tools / Options / SQL Server Object Explorer / Scripting / Script for server version is set to 2008. If it is set to 2005, it will not script the where clause, because obviously that script would not work if you ran it on 2005.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft