<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
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 Steve Jones
»
SQL Server Agent Roles
37 posts, Page 1 of 4
1
2
3
4
»
»»
SQL Server Agent Roles
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, March 21, 2012 9:16 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425,
Visits: 13,738
Comments posted to this topic are about the item
SQL Server Agent Roles
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1270607
zerko
zerko
Posted Wednesday, March 21, 2012 9:19 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 8:43 PM
Points: 525,
Visits: 381
Got this right, on the assumption 'SQLAgentAgentRole' was meant to be 'SQLAgentReaderRole', as none of the other answers were correct, and 'SQLAgentAgentRole' doesn't seem to exist.
Post #1270608
Koen Verbeeck
Koen Verbeeck
Posted Thursday, March 22, 2012 1:02 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373,
Visits: 6,470
Indeed, small typo in the correct answer.
However, very nice question, thanks Steve.
(you read that MSDN page one day and you thought: "I shall make 5 QotD of this!"?
)
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1270637
kapfundestanley
kapfundestanley
Posted Thursday, March 22, 2012 1:22 AM
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 1:47 AM
Points: 774,
Visits: 1,047
The typo costed me for real,what is 'SQLAgentAgentRole' thought that was a trick any the only meaningful and true answer was the first one,although it did include all the three roles.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1270644
khelloufsofiane 6183
khelloufsofiane 6183
Posted Thursday, March 22, 2012 1:35 AM
Old Hand
Group: General Forum Members
Last Login: Monday, May 06, 2013 8:41 AM
Points: 374,
Visits: 124
Hi,
I got ot right, but should replace "SQLAgentAgentRole" with "SQLAgentReaderRole"
Thanks.
Post #1270647
paul.knibbs
paul.knibbs
Posted Thursday, March 22, 2012 2:25 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 1,257,
Visits: 4,257
kapfundestanley (3/22/2012)
The typo costed me for real,what is 'SQLAgentAgentRole' thought that was a trick any the only meaningful and true answer was the first one,although it did include all the three roles.
But the first answer ISN'T true--it's reversed; the SQLAgentReaderRole is a member of the SQLAgentUserRole, given the terminology used here. I don't agree with that terminology, mind you, because it would be far too easy for a newbie to confuse logins that are members of a role with this nebulous idea of roles being members of other roles that the question introduces. I suspect this is why the linked article never uses this terminology!
Post #1270657
Koen Verbeeck
Koen Verbeeck
Posted Thursday, March 22, 2012 2:39 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373,
Visits: 6,470
paul.knibbs (3/22/2012)
kapfundestanley (3/22/2012)
The typo costed me for real,what is 'SQLAgentAgentRole' thought that was a trick any the only meaningful and true answer was the first one,although it did include all the three roles.
But the first answer ISN'T true--it's reversed; the SQLAgentReaderRole is a member of the SQLAgentUserRole, given the terminology used here. I don't agree with that terminology, mind you, because it would be far too easy for a newbie to confuse logins that are members of a role with this nebulous idea of roles being members of other roles that the question introduces. I suspect this is why the linked article never uses this terminology!
Indeed, with simple elimination the correct answer could be deduced. Even if there's a typo in it.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1270661
skanker
skanker
Posted Thursday, March 22, 2012 2:50 AM
Say Hey Kid
Group: General Forum Members
Last Login: Yesterday @ 1:57 AM
Points: 693,
Visits: 1,022
Thanks for the question. I think even with a small typo the answer was relatively straightforward. Three right in a row - I must be on a roll.
Post #1270669
baabhu
baabhu
Posted Thursday, March 22, 2012 3:02 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 1:58 AM
Points: 1,112,
Visits: 970
Thank you for the easy and straight forward question....
Post #1270678
kaspencer
kaspencer
Posted Thursday, March 22, 2012 3:46 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 10:36 AM
Points: 1,404,
Visits: 253
Why is the number of errors in Questions of the Day so great?
How are we supposed to interpret typographical errors?
I have yet to build the stored procedure SP_ESP so I simply did not treat SQLAgentAgentRole as a typographical error - I treated it as a distractor.
A message to Steve Jones: Steve, appoint a named reader of every QotD
before
questions are used on the site. Otherwise, SACK those question-writers who do not read their submissions properly.
One thing is for sure - all those submitters of duff questions will not be recommended to my clients - no doubt their coding is as error-prone as their questions.
Kenneth Spencer
Post #1270694
« Prev Topic
|
Next Topic »
37 posts, Page 1 of 4
1
2
3
4
»
»»
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.
