If you right-click on the job in SSMS, and hit view history, does it come back with anything at all?

I have a server that gets rebooted every Sunday at 4AM that is hanging up somewhere in the process. If we go into the server room, point the KVM...

A much quicker way if you can get away with it... 🙂

1) Send an e-mail out to everyone who has a good knowledge of your environment with a list...

Does Litespeed not have something built into it to help you set that up?

Just out of curiosity, anyone ever actually created (or seen) a server with 50 instances of SQL installed on it? Most I've ever done is 6.

We had a simlar thing happening several months ago on several non-clustered SQL servers after upgrading to SQL 2005.

We ended up finally tracking it down to a 3rd...

Good question!

No, it was a tear of Joy!

None that I've ever encountered.

Wonderful...brought a tear to my eye!

Jack Corbett (12/23/2008)

It sure is. I think a lot of resumes...

So should posters take it as a compliment that someone was able to fake an interview with SSC posts, or as an insult?

I've also looked at a post or two...

Oh, yea, if you have the DB attached somewhere you can just query out of the system tables.

I'm not sure that will make the script any easier to...

You can use RESTORE FILELISTONLY to get a list of the files in the database.

I would argue that a snapshot is a form of backup. I realize it can't be used if the source database is physically gone, but you can revert from...