Interesting comments, I'll have to think on a few before posting more.]

As an FYI, Lynn has a great blog here on this same subject.

Roy,

Hope things are well with you and my thoughts and prayers for your family.

Dan,

I'll add the MP3 feed to itunes as well.

Try this: http://www.sqlservercentral.com/scripts/31776/

There should be only one MDF file for each database. You can try to attach them and get some info from each one as you do.

If you have multiple ones...

Use the dynamic properties task to find the name (query, file, etc) and then you can use a script task to change the name

This might help: http://www.sqldts.com/241.aspx

Closed

Barry,

I don't think it was a rude response, but it was a little short. However it's not even close to something I would remove.

My thoughts on a standard response as...

I've often thought the production DBA should be insurance. If he/she's doing the job, you pay him/her, and don't worry about things. That's a big IF, however, and when something...

Ah, the old power outage trick.

I used to work with a bunch of programmers that wanted their offices dark, and by dark, I mean no lights, shades drawn tight, and...

That was a nice link, John. Any thoughts to writing it up a little more formally, and submitting at an article?

We do not, as a rule, like to answer interview or homework, as stated.

That being said, I can see where you thought the first response was a little short, and...

Here's the thing. What scale are you talking about? Because a script to check things automatically would require a bunch of testing from you, and in that time, you might...

Maybe you could elaborate on what issues you're having and what you see as a problem.

You could script the attaches,but you've have to know something about them. RESTORE HEADERLIST will give you some info.

Are these one database or multiple ones?