Viewing 15 posts - 8,626 through 8,640 (of 9,720 total)
You should do regular database size checkups to see how often and how much your database grows on a weekly & monthly basis. Then configure your max database size (presuming...
September 30, 2008 at 7:08 am
Try dumping their DNS cache and see if that works. It might be that these servers have a specific DNS name that hasn't (for whatever reason) been refreshed on those...
September 25, 2008 at 7:41 am
Adrian & Steve,
I would love your help. :w00t:
I'm in no rush, so take your time. And you can do as many or as few of my articles as you...
September 25, 2008 at 5:14 am
Congratulations!
The first step is always the hardest. @=)
September 24, 2008 at 6:12 am
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...
September 19, 2008 at 5:01 am
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
Viewing 15 posts - 8,626 through 8,640 (of 9,720 total)