2008 RTM, SSMS/Engine: Table designer doesn't script WHERE clause in filtered indexes - by Brandon.Tucker

Status : 


Sign in
to vote
ID 362699 Comments
Status Active Workarounds
Type Bug Repros 7
Opened 8/20/2008 2:28:04 PM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Sravanthi [MSFT] 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".

Sravanthi Andhavarapu,
SQL Server Manageability Team
Posted by Microsoft 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
Posted by Microsoft 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.
Posted by Brandon.Tucker 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.
Posted by AaronBertrand 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.