thank you. that is what I was looking for.

good information. thanks

It worked. No problems. thanks

will try. thank you

I wanted to test the explicitly granted showplan permissions.

Thank you for responding so quickly. Every bit of explanation helps. That will make it easier to build indexes to change the index scan into an index seek. Thanks again.

thank you for the explanation. I did not pick up on the linked server. I suppose the linked server connect to the active directory data store against which the query...

One bit of information, this query is used to read the active directory.