>This should always give you a filtered view if SET DELETED is OFF, or SET DELETED is ON and you have an index on DELETED() and SET COLLATE does match the index expressions. If you usually don't get a filtered index, I would be interested to find out why you don't get one. Can you verify that you indeed get a filtered table?
I tested last week with an index on Deleted(), but have never used COLLATE. The current setting is MACHINE. Does that affect it?
At this moment, I'm getting all filtered tables even with no index on Deleted(), and SET DELE ON, after trying several times. This morning and last week, I wasn't, as I say, it seems to be unpredictable...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.