actually sp_validatelogins gives me exactly what i'm looking for but that is half of the battle, now i need to find a good way to remove them (if they own...

i'm not sure you saw my last comment. back when i posted there was a bug with server names of 15+ characters. mine was 15 exactly.

That was it, the severname is 15 characters exactly. Thanks for the link

SQL Noob,

We use DL380 G5's as well, our default build sets it to 50/50..  What did you change it to on your SQL Server?  Did you notice any benefit?

I have also read that moving your SQL install to another drive may cause you further pain down the road as upgrades and patches are deployed.  I would recommend leaving...

The way I read books online is that you only have to set max memory differently than its default setting is if you have other applications running on your SQL...

i am able to get this to work on anything before SQL 2005 SP2, is that what others are experiencing?  I have also rolled it up with the cumulative hotfixes...

Has anyone had any luck fixing this?  I also have this error and have not moved msdb.

I was having the exact same problem, if you do resolve the issue please share!

There is a hotfix related to Database Mail and SP2, I'm not positive the KB article off the top of my head but do a search on microsoft's website