I prefer Transcendor myself. Plus Microsoft's website for certification usually has a 10 question "sample" you can look at.

If you get more cert study books, aside from the training...

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...

NP. Glad I could be of help.

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...

Pretty similar, yes. @=)

Okay, I see what you're saying now.

Sorry about the dizoid moment. Thanks for your help!

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...

Thanks for the link, Peter.

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...

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?

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...

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...

Me too. Which means I can't fiddle with SQL 2008 nearly as much as I want to.

@sob!

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...

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...