There are, but unfortunately we don't have enough good...

I think you're ready to be a DBA some day! It's unintuitive for many people, but I tend to agree with you....

homebrew01,

Please update us if you learn anything from the advice here. This is a great discussion.

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...