You know what? I think some of us (me included) really need a vacation in some far off exotic locale. Too bad I can't afford one...

Reminds me of the answers...

Alvin Ramard (5/20/2009)

---

Lynn Pettis (5/20/2009)

---

Alvin Ramard (5/20/2009)

---

Lynn Pettis (5/20/2009)

---

You know, there are a few people who just need to walk away from the computer and get a job flipping burgers...

Glad to help.

Alvin Ramard (5/20/2009)

---

Got it!

Oh, what's...

This may not answer your question directly, but I think it will help you figure it out, read this blog post: A Variable Length Random String.

I think you will find...

You know, there are a few people who just need to walk away from the computer and get a job flipping burgers or something.

aprasy (5/20/2009)

---

Hi All,

I am newbie in dba side. I have a question in backup. I had tried to backup the database...

If you really must, he's here.

Bob,

Steve locked the other thread before I could reply to you (that's what i get for reporting it to him).

Yes, we are getting close to 5,000 posts here.

Did you notice...

cos_ta393 (5/20/2009)

---

Hi,

I am experiencing an issue with missing job history and I am not sure what is going on. I do have SQL Server Agent properties for History configured using...

Best place to start, lookup functions in BOL (Books on-Line).

Looks like this post is now here.

Would you please post your query.

Not having any DDL or sample data available (sorry, but I'm not taking the time to create it), the simpliest way to do it based on what you have provided...