Gail, Jeff & Steve are the three MVP's I know that haunt this thread. After I posted to the blog I had a different MVP send me a direct message...

Posted on the blog and didn't mention names or start a fight:

http://scarydba.wordpress.com/2009/03/04/bad-performance-tip/%5B/url%5D

Someone else mentioned checking the Agent error log specifically, not just the SQL Server error log. Other than that, I'll let the reinforcements take over.

Oh man, I was counting on you guys. I get in over my head.

Good old fashioned sp_who2 could help here too.

You don't want to run Profiler on your production system. What you want to do is set up a server side trace. It's...

Ninja's_RGR'us (3/4/2009)

---

Holly crap!! If THAT GUY is an MVP, why the hell didn't I ever make that list?

Looks to me like we need about another 2000 MVP nominations just...

GilaMonster (3/4/2009)

---

Grant Fritchey (3/4/2009)

---

I've been running a loop of "I love living in the city" by the Fear in my head for days now, so, I'd almost welcome the Star...

I've got a poster that I really don't know how to help.

http://www.sqlservercentral.com/Forums/FindPost668188.aspx

I'm not aware of one. Hang on a sec. Let me get help.

Bob Hovious (3/4/2009)

---

Grant, I've read somewhere a while back that this...

GilaMonster (3/4/2009)

---

Grant Fritchey (3/4/2009)

---

Another one. This was interesting. If you spot something wrong with my tests, let me know. This is going up as a blog post, with names changed...

I don't know. I'm not sure you can modify it. If I look at the SQL Server Configuration Manager, I can see the settings within the Agent, but it's not...

Another one. This was interesting. If you spot something wrong with my tests, let me know. This is going up as a blog post, with names changed (and grammar fixed...

Bob Hovious (3/4/2009)

---

To my knowledge, I have never used a GROUP BY without an aggregate...

Check the service for Agent to be sure it's running under an account that has appropriate priveleges on your server.