Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Role Membership Expand / Collapse
Author
Message
Posted Wednesday, October 21, 2009 11:00 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Comments posted to this topic are about the item Role Membership

http://brittcluff.blogspot.com/
Post #806943
Posted Thursday, October 22, 2009 2:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:59 PM
Points: 1,738, Visits: 483
OK, so why did my server return NULL ?

Kenneth Spencer
Post #806986
Posted Thursday, October 22, 2009 2:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 5, 2014 7:57 AM
Points: 558, Visits: 1,481
As did mine. I want my point back
Post #807002
Posted Thursday, October 22, 2009 4:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,467, Visits: 6,438
Mine did too, but you guys didn't read the question properly. It says select all that apply! And a little check in BOL would have revealed that IS_MEMBER can return 0, 1 or NULL, so no points back

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #807033
Posted Thursday, October 22, 2009 5:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
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.

http://brittcluff.blogspot.com/
Post #807043
Posted Thursday, October 22, 2009 6:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 2,576, Visits: 3,827
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.
Post #807096
Posted Thursday, October 22, 2009 6:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 7:39 AM
Points: 9, Visits: 26
I agree the wording could have been better. D'oh!
Post #807104
Posted Thursday, October 22, 2009 7:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,467, Visits: 6,438
Now what's so unclear about What are the valid return values for the following code: (select all that apply)? I've seen QotD's that were WAAAY more misleading.

PS: I was not the one who submittted the question


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #807126
Posted Thursday, October 22, 2009 7:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:44 AM
Points: 1,068, Visits: 1,432
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
Post #807145
Posted Thursday, October 22, 2009 8:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
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.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #807201
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse