This looks quite interesting!  My only concern with something like this is in a larger company that employees over 250+ developers (where I work), it appears to give too much...

No problem.  Your code could very well be what I'm looking for to get started on a self-help database restore section of my app.

Thanks again!!

I've been writing a webapp for years that monitors current backup\restores of all our production\development environments.  Below is a screenshot of what that screen looks like:

Something...

• This reply was modified 5 years, 6 months ago by  John Waclawski. Reason: Fixed my signature which was broken

I realize this is a very old thread but thought I'd throw this out there in case someone else has experienced it.

This code is almost exactly what I...

Ed Wagner (10/2/2014)

---

John Waclawski (10/2/2014)

---

Jeff Moden (4/29/2012)

---

Same way as when testing any software of old......

Jeff Moden (4/29/2012)

---

Same way as when testing any software of old... Add a PRINT or...

We backup the databases on the production server. No need to backup the database on the reporting server (the replicated server). Would be rather redundant.

Also, the T-SQL Checkpoint...

robertd 77391 (3/12/2013)

---

DISTINCT(sj.name)

That doesn't return unique names, distinct returns unique rows:

DISTINCT

Specifies that only unique rows can appear in the result set. Null values are considered equal for the purposes of...

Ahhhh....That did the trick!!...

I just figured out what my issue was. And as usual, it was something I was doing wrong. Albeit it's odd it works this way.

I was...

I too am running into this with SQL Server 2008 R2 at the moment.

I'm getting a subject line, no body text. Still plugging away at it. If I...

Be leary about this SQLJOBVIS web page. ...

LOWELL!! MY SQL HERO!! Let me give this a shot & see how it works!

Thanks. BTW...did you get my reply from our other thread?

Ironically I had that very same page opened when I wrote the email. But it didn't say how to implement that code...

I'm sorry, Lowell. Yes. This has been a outstanding success!!!

I got a little trigger happy on several issues I'd like to *cough* "monitor" and my manager had to...