Viewing 15 posts - 8,641 through 8,655 (of 9,725 total)
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
I look forward to meeting you, Jack! @=)
September 16, 2008 at 7:45 am
Nope. I spoke at the Jacksonville, Florida SQL Saturday also. It's funny. I subbed for the Backup / Restore session at the last moment and found out I knew more...
September 16, 2008 at 5:27 am
WHOO HOO! I've had 2 sessions accepted!
Disaster Recovery: Preparing for the Storm and The Nitty Gritty of Database Backups. Both beginner level sessions. Better start working on my power...
September 16, 2008 at 4:31 am
Gosh darnit. Something must be wrong with my site PM & Email.
Ninja, send me an email to goldpetalgraphics@yahoo.com. I'll reply with a different email address from allstate, but I don't...
September 15, 2008 at 4:08 am
Apparently my PM isn't working. Go to my profile and send me a personal email and I'll reply. And if you don't hear back from me by the next, post...
September 12, 2008 at 3:37 pm
Viewing 15 posts - 8,641 through 8,655 (of 9,725 total)