Viewing 15 posts - 8,626 through 8,640 (of 9,715 total)
Hmm. Interesting. But it sounds awfully bulky and hard to maintain to me.
There's no way I would want to implement something that "complicated" in my environment. We'd constantly be forgetting...
September 19, 2008 at 4:33 am
Sensitive information should NEVER be included in a configuration if you can avoid it. If you can't avoid it, don't use XML or any other feature that leaves the password...
September 18, 2008 at 11:20 am
Okay, I see what you're saying now.
Sorry about the dizoid moment. Thanks for your help!
September 18, 2008 at 10:53 am
Riga,
In every and any instance, the correct answer is "It Depends". @=)
Which configuration file is easier for you depends on how your environment is set up.
For my workplace, our...
September 18, 2008 at 10:38 am
Thanks for the link, Peter.
September 18, 2008 at 10:31 am
I just noticed something interesting and annoying.
When I add the system db roles to JobOperator, it makes JobOperator the owner of those schemas. When I go into Schemas and change...
September 18, 2008 at 4:11 am
Ed,
I can't add JobOperator to SQLAgentOperatorRole. It doesn't show as available when I try. So how am I supposed to get this to work?
September 18, 2008 at 4:05 am
I created a role in msdb called "JobOperator" with the owner of "dbo". I assigned other roles to it rather than specific permissions. The roles assigned are as follows:
SQLAgentUserRole
SQLAgentOperatorRole
db_datareader
SQLAgentReaderRole
db_dtsadmin
Then I...
September 17, 2008 at 10:45 am
Well, I figured out what the problem was. I tried assigning all these permissions to a database role and then adding the user to the database role and no matter...
September 17, 2008 at 8:27 am
Me too. Which means I can't fiddle with SQL 2008 nearly as much as I want to.
@sob!
September 16, 2008 at 12:04 pm
I tried instance level refreshing and it didn't work. I'm going to try again tomorrow. It might be a cache refresh issue on the user's PC if other people are...
September 16, 2008 at 12:02 pm
Well, see, that's what I wasn't sure about. How the global policies in 2008 actually functioned under the hood, that is.
I'm referring to a situation that I ran into with...
September 16, 2008 at 10:51 am
Michael,
I appreciate the response, but it didn't work. The user still can't see any of the jobs or even open the Job Activity Monitor. SQL Server Agent isn't even...
September 16, 2008 at 10:47 am
Viewing 15 posts - 8,626 through 8,640 (of 9,715 total)