Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

SQL Server Agent Roles Expand / Collapse
Author
Message
Posted Wednesday, March 21, 2012 9:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:27 PM
Points: 33,942, Visits: 18,049
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
Posted Wednesday, March 21, 2012 9:19 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 4, 2016 12:06 AM
Points: 940, Visits: 712
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
Posted Thursday, March 22, 2012 1:02 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, July 22, 2016 2:43 AM
Points: 15,240, Visits: 13,054
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1270637
Posted Thursday, March 22, 2012 1:22 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 4:14 AM
Points: 986, Visits: 1,206
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
Posted Thursday, March 22, 2012 1:35 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: Wednesday, March 2, 2016 3:02 AM
Points: 561, Visits: 179
Hi,

I got ot right, but should replace "SQLAgentAgentRole" with "SQLAgentReaderRole"

Thanks.
Post #1270647
Posted Thursday, March 22, 2012 2:25 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 22, 2016 3:12 AM
Points: 1,807, Visits: 6,108
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
Posted Thursday, March 22, 2012 2:39 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, July 22, 2016 2:43 AM
Points: 15,240, Visits: 13,054
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1270661
Posted Thursday, March 22, 2012 2:50 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 12, 2015 5:07 AM
Points: 969, Visits: 1,385
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
Posted Thursday, March 22, 2012 3:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 22, 2016 2:54 AM
Points: 1,369, Visits: 1,214
Thank you for the easy and straight forward question....
Post #1270678
Posted Thursday, March 22, 2012 3:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 21, 2016 2:09 AM
Points: 2,245, Visits: 739
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


You never know: reading my book: "All about your computer" might just tell you something you never knew!
lulu.com/kaspencer
Post #1270694
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse