MadAdmin (3/31/2015)
When using Filtered indexes, just be careful of Procs where Quoted_Identifier is OFF for the update inserts.You can find this by selecting * from sql_modules where quoted_identifier is off, to see which procs are impacted, and then join those to syscomments to find the procs which use the table.
Also double check Triggers as well. As it's unlikely, but possible Quoted_Identifier is set to off. It's also in sql_modules. Just yesterday, I had set quoted_identifiers to On for around 40 SP's due to a new filtered index. Luckily, it didn't cause other conflicts by changing the status to On.