Nice approach. That's the kind of response I like to see.

Culprit

GilaMonster (1/21/2014)

---

I would consider myself a reasonably competent writer, English is my first language and I've been writing for years. I still, when I submit something for review, get it...

GilaMonster (1/21/2014)

---

SQLRNNR (1/21/2014)

---

GilaMonster (1/21/2014)

---

Be patient.

The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the...

Here...

Nice article Rodney.

I have built redundant alerts in the past and had gotten away from it. But, it makes a lot of sense. Especially considering the high frequency...

Gary Varga (1/20/2014)

---

This is key. The same is true with the communications...

Thanks Steve.

I agree with the notion to blog. Besides the improvement in writing skills and the practice at doing it, it has also helped me to become a better...

Amazing how that works.

Great advice Chris. Sometimes the most...

While waiting for it to come online, have you checked the disk system? Have you checked general server health? Have you checked permissions (make sure they haven't changed)?

Your...

clyde_mcmurdy (1/20/2014)

---

My apologies to the OP for the thread hijack.

Should I start a new one?

"... ProcedureName WITH RECOMPILE means that the procedure's plan is never cached at all"

That's...

Here's a script to help with that

http://jasonbrimhall.info/2011/11/16/table-hierarchy-goes-cs/

As the post cautions, the script slows significantly when dealing with circular references.

Nice Script Perry. When transferring logins, I will always go for the script approach similar to what Perry has shared.

Is your database back online?

Rockford