Steve Jones - Editor (3/22/2010)

---

Conrgats, Gus! After 11 years, my wife and I got a honeymoon this year. Hoping we'll renew here at some point.

Have to be close to home...

Just...

I guess the questions will depend on what you've claimed competence in on your resume as compared to what they have requested competence in on their job description.

Hard to guess...

Gail, isn't that supposed to have the image of a cat-like pupil floating amidst the flames?

Alvin Ramard (3/22/2010)

---

Lynn Pettis (3/22/2010)

---

GSquared (3/22/2010)

---

My main subjects of conversation so far today have been politics...

Lynn Pettis (3/22/2010)

---

GSquared (3/22/2010)

---

My main subjects of conversation so far today have been politics (Obamacare passed...

My main subjects of conversation so far today have been politics (Obamacare passed the House late...

So far as I know, SQL 2008 blocks modification of system procedures.

But you can usually get their definitions and create your own versions of them. Wouldn't that allow you...

Have you tried the Database Diagrams tab under the database name in Management Studio?

If that's the case, that this can be lost without hurting the business at this point, then make sure your other databases on that server are all both currently okay...

AD tokens aren't a DBA thing. They're network security. WAY outside what most DBAs would be fiddling with.

One idea that I'm not sure you've tried yet, though you may...

Yes. There are products that will monitor that kind of thing for you. I've used "What's Up Gold" for that kind of monitoring before. It has several...

Rebooting the server will either result in it trying to finish the rollback, or labelling the database Suspect if it simply cannot finish the rollback. It probably won't solve...

"Suspect" means the service can't access the database correctly.

Check the error logs. They'll usually tell you the exact problem.

Honestly, I'd have to actually dig into the servers to know exactly what to tell you to do at this point.

Without that, I'm kind of shooting in the dark a...