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 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 @ 4:29 PM
Points: 32,819, Visits: 14,965
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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 10:43 PM
Points: 767, Visits: 610
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:23 AM
Points: 12,228, Visits: 9,202
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
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: 2 days ago @ 2:32 AM
Points: 937, Visits: 1,154
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:40 AM
Points: 425, Visits: 145
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: Today @ 12:19 AM
Points: 1,529, Visits: 5,188
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:23 AM
Points: 12,228, Visits: 9,202
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
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: Today @ 1:36 AM
Points: 830, Visits: 1,146
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: Wednesday, April 02, 2014 9:27 PM
Points: 1,242, Visits: 1,097
Thank you for the easy and straight forward question....
Post #1270678
Posted Thursday, March 22, 2012 3:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:12 AM
Points: 1,641, Visits: 423
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 »

Add to briefcase 1234»»»

Permissions Expand / Collapse