SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Britt Cluff / Role Membership / Latest Posts

RE: Role Membership

chinnulu — Sat, 12 Dec 2009 00:20:57 GMT

I tried this with 1. Taking a valid domain and role and got 1 as output2. Taking a Invalid domain and role and got NULL as output3. But, when i tried a Valid domain and invalid role, still i'm getting NULL as output.Anybody help me with a sample scenario, to see 0 as output

RE: Role Membership

RBarryYoung — Sat, 28 Nov 2009 13:44:36 GMT

I do think that these multi-selection questions should be worth at least 2 points.

RE: Role Membership

SanjayAttray — Thu, 22 Oct 2009 10:10:59 GMT

Executed query on SSMS and got result NULL. HUUUHHH.Didn't read select all that apply and just selected NULL and lost a point.Don't know how many points I lost by not reading -- select all that apply. May be 30 - 40 points.My bad. Always repented on answer in hurry.

RE: Role Membership

mtassin — Thu, 22 Oct 2009 08:11:56 GMT

[quote][b]skjoldtc (10/22/2009)[/b][hr]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.[/quote]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.

RE: Role Membership

paul.goldstraw — Thu, 22 Oct 2009 07:25:52 GMT

Yeah it was perfectly easy to understand. Plus it would be a radio-button answer if it could only be one of them, multiple choice implies multiple results

RE: Role Membership

Jan Van der Eecken — Thu, 22 Oct 2009 07:13:57 GMT

Now what's so unclear about [b]What are the valid return values for the following code: (select all that apply)[/b]? I've seen QotD's that were WAAAY more misleading.PS: I was not the one who submittted the question :cool:

RE: Role Membership

jkraemer — Thu, 22 Oct 2009 06:57:54 GMT

I agree the wording could have been better. D'oh!

RE: Role Membership

OCTom — Thu, 22 Oct 2009 06:48:35 GMT

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.

RE: Role Membership

Britt Cluff — Thu, 22 Oct 2009 05:11:41 GMT

Jan has is correct. There is 3 possible returns. If a valid Domain and Group are provided the function will a 0 or 1 depending on whether the user is a member or not. If the Domain or Group do not exist, the function will return a NULL.

RE: Role Membership

Jan Van der Eecken — Thu, 22 Oct 2009 04:56:26 GMT

Mine did too, but you guys didn't read the question properly. It says [b]select all that apply[/b]! And a little check in BOL would have revealed that IS_MEMBER can return 0, 1 or NULL, so no points back ;-)

RE: Role Membership

Chris Houghton — Thu, 22 Oct 2009 02:55:53 GMT

As did mine. I want my point back :crying:

RE: Role Membership

kaspencer — Thu, 22 Oct 2009 02:11:36 GMT

OK, so why did my server return NULL ?Kenneth Spencer

Role Membership

Britt Cluff — Wed, 21 Oct 2009 23:00:01 GMT

Comments posted to this topic are about the item [B]Role Membership[/B]