• Thank you both for posting. Brandie, you confirmed what I was seeing. And Karl you showed me what I suspected all along, that there's some problem with aliasing my user name.

    It's a shame that BOL does not explain this better and that Is_member requires the run as statement to make it work as expected.

    Thanks for your help, I hope to return the favor sometime.

    Doug


    Doug