Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Britt Cluff
»
Role Membership
13 posts, Page 1 of 2
1
2
»»
Role Membership
Rate Topic
Display Mode
Topic Options
Author
Message
Britt Cluff
Britt Cluff
Posted Wednesday, October 21, 2009 11:00 PM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588,
Visits: 247
Comments posted to this topic are about the item
Role Membership
http://brittcluff.blogspot.com/
Post #806943
kaspencer
kaspencer
Posted Thursday, October 22, 2009 2:11 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 8:30 AM
Points: 1,418,
Visits: 267
OK, so why did my server return NULL ?
Kenneth Spencer
Post #806986
Chris Houghton
Chris Houghton
Posted Thursday, October 22, 2009 2:55 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, June 06, 2013 5:57 AM
Points: 557,
Visits: 1,365
As did mine. I want my point back
Post #807002
Jan Van der Eecken
Jan Van der Eecken
Posted Thursday, October 22, 2009 4:56 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:29 AM
Points: 2,307,
Visits: 6,089
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
--------------------------------------------------------------------------
The function of good software is to make the complex appear to be simple. (Grady Booch)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #807033
Britt Cluff
Britt Cluff
Posted Thursday, October 22, 2009 5:11 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588,
Visits: 247
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
OCTom
OCTom
Posted Thursday, October 22, 2009 6:48 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 2,030,
Visits: 2,869
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
jkraemer
jkraemer
Posted Thursday, October 22, 2009 6:57 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, July 09, 2012 12:09 PM
Points: 6,
Visits: 16
I agree the wording could have been better. D'oh!
Post #807104
Jan Van der Eecken
Jan Van der Eecken
Posted Thursday, October 22, 2009 7:13 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:29 AM
Points: 2,307,
Visits: 6,089
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
--------------------------------------------------------------------------
The function of good software is to make the complex appear to be simple. (Grady Booch)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #807126
paul.goldstraw
paul.goldstraw
Posted Thursday, October 22, 2009 7:25 AM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, May 28, 2013 9:52 AM
Points: 814,
Visits: 1,137
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
mtassin
mtassin
Posted Thursday, October 22, 2009 8:11 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 3,250,
Visits: 65,547
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 »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.