Thanks, Howard. I have both 2k5 and 2k8 R2 installed on my laptop and I can only find one version of that file, exactly where you said it was. However,...

This is probably a little late for you, but I really wouldn't have used a loop for this delete. I'd have gone with the straight delete, but changed the Archive...

Just because I'm paranoid doesn't mean people aren't out to get me.

FYI: It's "plan", not plain. There's no "i" in the word.

The GUI won't help you with this. None of the available...

Relax

Chris's suggestion was where I was going with my subquery comment.

Consider also if you'll ever have Opn and Beg as Statuses, or Opn and Pro as opposed to the Beg...

kashif.nadeem (3/17/2011)

---

3a) Please review your linked server and tell me what security options are set on it. Then, if mapping to a specific login, go to the source database and...

CRAIG!

Stop giving me story ideas! I...

Tom.Thomson (3/17/2011)

---

Surely unless your minions are such extreme qermospodiaphiliacs that it distorts their perception they...

I could listen to Brian Knight talk about SSAS all day and still have to re-review all my notes to get half of what he's explaining to his class.

I'm glad...

Kiara (3/17/2011)

---

Referring to your own writing is just common sense. No different than reviewing your own notes on a topic. *Creepy* is when you google something that you don't know...

kd11 (3/17/2011)

---

Ok, I'm using sp_send_dbmail but the if my maintenance plain is creating a text document with the date and a runtime as the name of the file how do...

Every so often, I stop and remember that I learn (or remember) things much better if I have to explain it or teach it to someone else.

I thought about...

Ah, yes. The good old network backup. Actually, the bad old network backup.

Don't use them. Make all your backups locally, then move them over the network. That way, if the...

hector__21 (3/17/2011)

---

Brandie Tarvin (3/16/2011)

---

You can also put a CASE statement in your ON clause, forcing the code to make up a number or default to a value that will keep...