• Offhand, I have no idea and you're dealing with some really idiosyncratic glitch. I'm relatively sure you won't know for sure unless you call Microsoft and they look into what the component is doing directly.

    That said, I've seen it before, but only once, and that was 2k5. I used the same method to avoid it, simply using a T-SQL call to force it to read the view properly, and including the NOEXPAND hints as necessary.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA