I agree ,

This is working now and looks like a user error on my part.

With your validation, it helped me discover the bug

Thanks

Richard:-)

I'm trying that exact test and I get an error message

"Cannot execute as the server principal because the principal "MYDOMAIN\test11" does not exist, this type of principal cannot be...

I will try this. Thanks

RBarryYoung,

Exactly what I needed. Thanks for your HELP !

Graham,

Yes, I have some predefined where clauses stored in tables

Thanks,

It turns out the network folks thought they had permissions set but really didn't

Its working now