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

I guess it would depend on the calendar used on other planets...

I mean,...

Why isn't it Friday yet?

Despite being something of a virtualization fanatic myself, if the application Vendor won't support their app if the SQL is virtualized, stick to your guns.

And get documentation from the vendor...

Thanks Gail!

My plan is:

1. Compress the Clustered Index / Data

2. Shrink the file

3. Rebuild the Clustered Index

4. Compress and rebuild the non-clustered indexes

Once more, thank you!

Jason

Hipster

Evil Kraig F (5/13/2013)

---

So, I don't feel that I'm doing one of our posters justice on a topic he's posted. I've gotten a very polite blow off. Not...