skjoldtc (10/22/2009)
I think the quesiton could have been worded better. Something like "What are the valid values that can be returned by IS_MEMBER?"The question implied or I inferred that we had to use the exact code.
😉
I believe I read somewhere that this is deprecated or will be.
SELECT IS_MEMBER('DOMAIN\SuperUsers')
Unless you're on an AD domain named DOMAIN, this will obviosly not work. However, if your NT admin had named your domain DOMAIN and created a group called SuperUsers within it, it would work.