I have to wonder how often Gail and the other pros here get frustrated with people asking questions where the answer is in the message SQL spit out?

I'm thinking permissions are beyond stuffed at this point...

I tried Foxxcos' idea, and there are NO errors / warnings / critical events logged in the WMI log when I try...

Alai

Foxxco, thanks for the idea...

Now if only the guys I work with would text me back, so I could point them to your suggestion...

Kind of hard to work from an...

Tried that early on, made no difference...

foxxo (5/26/2013)

---

What error is in the Windows Application log? What error...

the SQL Server service account is a member of the local Administrators group

Couple more things, about the same server:

I'm unable to create a new database (also throws an access denied)

OS: Server 2008 SP2

SQL: SQL Server 2008 R2 SP1

Everytime I see one of those, I want one...

Just not sure what I'd do with it...

BDSM

(to risque'?)

Brandie Tarvin (5/24/2013)

---

#headdesk

Aren't Friday's supposed to be the easy day of the week?

Nothing worse than coming into the office (after a late night doing scheduled maintenance) and hearing "the vendor...

Quite annoying when you're trying to get things to a state where the customer can test while you're on vacation (ideally without having to pester the backup guy too much)...

I would expect so.

Create an Agent job, make the step a "T-SQL" step, and put your T-SQL in the box. I would suggest perhaps either restoring a copy of...

Lynn Pettis (5/17/2013)

---

Lynn Pettis (5/17/2013)

---

And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't...

Yes, I can re-jigger the trace to use the DB ID.

I'll also look into setting this up with Extended Events, instead.

Thanks Grant!

Jason

With an announcement from the Oracle DBA I work with, I now know what the people I used to work with felt like when I announced I was leaving...

Worse, he's...